Content
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
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…


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:…
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"…
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: …


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…
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…
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…


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


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.


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…


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…


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…


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…


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
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…


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?
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…


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


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 ?