A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
SQL Server Reporting Services
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Server temporal tables - storing the user who deleted a row
Hi all; I am going to use temporal tables to keep a full audit trail of all changes to records in my key tables. One thing I have already implemented is each of those key record models implements: public interface IAuditTrail { /// <summary> …
Azure SQL Database
An Azure relational database service.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How To send mail with attachment from SQL MI
Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Express ODBC Connection
Hi, I am trying to connect UPS WorldShip to a SQL server to pull shipping data. It keeps telling me the connection has failed, this is a replacement server, the old server still connects. I turned off the firewall on the server for testing, I…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
The error was while running the store procedure runs xp_cmdshell to run a batch file
The stored procedure SP_CreateClientDatabase internally uses xp_cmdshell to execute a batch file located at: F:\ECLOUD_DB_Script\CreateDB.bat However, the execution is currently failing with the below error:An error occurred during the execution of…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Mssql Log Shipping Requirement
I want to know about Mssql Log Shipping requirement to make it and the setup in details
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Product Key
I need the SQL product key. I purchased SQL 2019 Standard but can not get to the product key.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Breaking Changes - SQLOLEDB to MSOLEDBSQL/MSOLEDBSQL19 (SQL OLE DB Provider to SQL OLE DB Driver)
Hello. Very much behind the times, one of our clients needs to migrate their applications from using SQLOLEDB to MSOLEDBSQL or better MSOLEDBSQL19 (i.e. the original OLE DB Provider for SQL Server to the latest OLE DB Driver 19 for SQL Server). …
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How to add PDF Ifilter for SQL 2025?
Hi everyone, I am recently facing an issue regard Full-Text indexing in SQL Server 2025. I have installed SQL 2025 with Full-text indexing. Then i install Adobe IFilter. Unlike SQL 2022, i am not able to find any output for pdf when i run the below…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
sql 2022 EXPRESS SDCO Error
Hello. i am having issue with installing SQL express 2022. basically i have a program that i am installing, but in the pre-req for that program i have to install sql 2022. while installing i get setup bootstrap error and in logfiles i see…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Azure ID Required
Why is an Azure ID required for Installing MS SQL Express
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
"'MSOLEDBSQL19' provider is not registered", but it is, and runs fine for weeks
We have a web application that runs with a connection string of Provider=MSOLEDBSQL19;uid=:U;pwd=:P;server=theserver;initial catalog=thedatabase;MultipleActiveResultSets=True;Use Encryption for Data=Optional;MARS Connection=True; The application will…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Server 2025 Standard Key not working for Power BI Report Server
I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Issues installing latest Microsoft OLE DB Driver for SQL Server ?
Hello, a machine has what looks like an old OLE driver as follows: Microsoft OLE DB Driver for SQL Server = Version 18.5.0.0 I downloaded and tried to install the latest at: Download Microsoft OLE DB Driver 19 for SQL Server (x64) I get the following…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Server Developer Edition – Request for Formal Clarification on Usage Restrictions and Boundaries
We are requesting formal clarification at an organisational level regarding the licensing limitations and permitted use of SQL Server Developer Edition, to support corporate governance and audit compliance. To ensure correct interpretation and consistent…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Setup issue on Sql express 2017
Hi, Do I need to create the instance before the setup can continue, for the issue below?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How to activate SQL 2025 license on SQL2022
Hello i bought "SQL Server 2025 Standart sürümü Kalıcı 1 Sunucu Lisansı ve CAL 10".Before i bought this license, i talked with two microsoft sale representative. They confirm that i can use this SQL 2025 license on SQL 2022. But when i try to…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL “untrusted domain” error over VPN for one device only (Windows Auth)
I’m looking for some advice on an issue affecting a single user/device when connecting to SQL Server over VPN. The user receives the following error when launching an application that connects to SQL Server using Windows Authentication: “Login failed.…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How can i install SQL server 2025 on AppVolume/Appstack VM
Hi EveryOne How are you? I like to install SQL Server 2025 + SSMS on AppVolume/Appstack(win 10) VM for all my users/VDIs in my organization. How can I do that? Is it possible? I know SQL server it is heavy software Thanks Michael
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories