SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,102 questions
Content
0 answers
How to pass an Image as a parameter to an SSRS Report
Hello, We need to pass an image as a parameter to an SQL SSRS Report. How would this be done since there is only a date, number, bit and text type for SSRS parameter types ? Thank you
1 answer
BULK INSERT with FIELDQUOTE
Can someone tell me why this doesn't work? Using SQL Server 2019. SSMS v18.1. FieldQuote option does not seem to be recognised by SSMS as it remains black rather than changing to blue for keywords. My data is as follows:- 12345, 124, "this…
asked 2023-01-31T16:38:57.29+00:00
JamesProsser
1
Reputation point
edited an answer 2023-01-31T20:42:29.2633333+00:00
Yitzhak Khabinsky
19,856
Reputation points
1 answer
SQL Server Migration Assistant for DB2 - Unable to connect using connection String Option
Trying to connect my Db2 server to the newly installed SSMA (V9.2). I have MS OLEDB installed (v6) and can connect successfully with the client however I can't run a samply query in MS OLEDB. In both tools, I'm getting the following error message:…
3 answers
Azure SQL DB audit stops working.
Greetings. I have a very simple Azure SQL DB audit that works exactly as expected... then stops overnight for some reason. So I can define my audit and confirm that it's set correctly: Set-AzSqlServerAudit -ResourceGroupName "myRG"…
1 answer
Error installing SQL Server: Exit code(Decimal):-2061893606 Error description: Wait on the database Engine recoveryhandle failed SQL installation failed
Hello, I have been having issues installing the sql server The error log I got is pasted below Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: …
asked 2023-01-31T09:39:28.58+00:00
Olusoji Daniel
0
Reputation points
edited the question 2023-01-31T17:44:54.65+00:00
Jeff McCashland
476
Reputation points Microsoft Employee
0 answers
Error Message in SQL Import and Export Wizard
I'm trying to import data into my SQL Server using SQL Server Import and Export Wizard and I keep getting this error message: TITLE: SQL Server Import and Export Wizard Could not retrieve table list. ADDITIONAL INFORMATION: A network-related or…
0 answers
Odata Source in Foreach Loop Container
I am trying to migrate the data from the same table for 15 companies in Odata Source using Foreach Loop Container (the number of companies may change). But, I have difficulties in making this process dynamic. I will appreciate if you can you share your…
6 answers
Migration of SQL Server 2016 to new Windows Server 2019 Standard Machine
Hi, We are planning to migrate all of our Windows Server 2012 R2 Standard to Server 2019 Standard. For this, we will have to migrate our SQL server 2016 (2 instances Running in windows cluster) to new Windows Server 2019 Standard server machines. We…
asked 2020-10-20T12:02:51.88+00:00
ahmed qureshi
21
Reputation points
commented 2023-01-31T17:00:56.79+00:00
MK@BWT
0
Reputation points
5 answers
Replication Monitor not working
Hi everyone, I recently noticed that replication monitor is not working properly. Whenever I try to launch it, the icon shows in the Taskbar of my indows but the application never actually open. Anyone with similar issue, please advise
asked 2021-10-01T20:36:18.02+00:00
tobz
161
Reputation points
commented 2023-01-31T16:56:58.8933333+00:00
Shawn Joyce
0
Reputation points
2 answers
How to access the SSRS report from another computer?
I have created a SSRS report on my local computer. Now I want to access (view) that report from another computer. Is it possible? If yes, please kindly suggest to me the procedure for that.
asked 2023-01-30T04:06:36.5833333+00:00
keshar joshi
0
Reputation points
commented 2023-01-31T16:20:37.5033333+00:00
keshar joshi
0
Reputation points
1 answer
Is there a way to check whether my nonclustered indexes are rebuilt while I rebuild my clustered index
Hi There, Is there a way to check whether my nonclustered indexes are rebuilt or not while I rebuild my clustered index. I just cant rely on create date and modified date in sys.all_objects. I am using create unique clustered index..with…
asked 2023-01-31T13:30:36.9866667+00:00
udhayan d
91
Reputation points
answered 2023-01-31T16:11:44.9066667+00:00
Zahid Nadeem
101
Reputation points
2 answers
how to get entries for a specific date?
Good morning all, We have MSSMS and our tables we have TimeStamp columns which are set as datetime. How can we select entries based on a specific date apart from using the below? SELECT * FROM table WHERE TimeStamp < '2021-09-03 23:59:59.999' AND…
asked 2023-01-31T09:50:27.7733333+00:00
George Botonakis
0
Reputation points
answered 2023-01-31T15:59:50.44+00:00
Jingyang Li
4,366
Reputation points
2 answers
MSsql. How to find position
Hi, I have geography object which contains many LINESTRING I want to give distance from this geography object and to find the position on the geography For example: Declare @g1 geography =geography::STGeomFromText('LINESTRING(7.068419558716859…
asked 2023-01-30T13:03:24.1+00:00
Lior Atzmon
0
Reputation points
edited an answer 2023-01-31T15:03:40.0933333+00:00
Viorel
82,646
Reputation points
2 answers
To eliminate duplications on some fields
Dear All, I have a table as shown below. You can see some duplications. My question is how to eliminate the duplications. The same question was asked on https://learn.microsoft.com/en-us/answers/questions/1163799/how-to-eliminate-duplication. Now the…
asked 2023-01-28T07:54:11.37+00:00
Anonymous
commented 2023-01-31T14:56:29.1066667+00:00
Anonymous
3 answers
SSRS report - Export hidden columns to Excel
Is it possible to export a report into Excel with some columns being hidden but not completely removed? Thanks
4 answers
Problems during installation of the reporting role in Configuration Manager
Greetings I'm having a problem installing the reporting role SCCM installed on server A SQL and Report service install in Server B But when I start configuring the role, it doesn't show me the name of my reporting role database I read several articles…
asked 2023-01-30T15:42:16.4266667+00:00
Aleksandr Terekhov
21
Reputation points
commented 2023-01-31T13:57:55.1233333+00:00
Aleksandr Terekhov
21
Reputation points
4 answers
can replication be limited to just some tables in the db?
hi , can replication be limited to just some tables on the db or must it be on the entire source db? and if the source has timestamps, will there be any problem for sql to keep them as is on the target/replicated db?
0 answers
Change Tracking - Multiple xdes_id in table [sys].[dm_tran_commit_table] for the same commit_ts
Change Tracking is activated on a Microsoft SQL Server 2012 To get the Commit Date of the changes we LEFT JOIN on table [sys].[dm_tran_commit_table] FROM CHANGETABLE(CHANGES [Grf].[ChangementStatut], 55169) ct LEFT OUTER JOIN…
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant
1
Reputation point
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant
1
Reputation point
1 answer
Is it possible to implement the custom security to the SSRS 2019?
Please share the code, if we can implement the custom security to the SSRS 2019
asked 2023-01-31T11:53:34.3966667+00:00
Chitravelu Sivanandam
0
Reputation points
answered 2023-01-31T12:09:19.37+00:00
Olaf Helper
25,721
Reputation points
1 answer
SQL Total_pages space is very high than the used_pages
Hi , For an Archival process we have swithced out a partition to a new table . but this table Totalpages used space is very high compare to the usedpages. what could be the reason for alocated_memory space is too high ?