21,625 questions with SQL Server-related tags
RedHat Linux 9.7 SQL Server 2025 CU2 Fails to write database backup to Linux NFS Share
Hello, I have a VMWare VM running RedHat Linux 9.7 and SQL Server 2022 CU 23. SQL Server 2022 can successfully write database backups and the mssql agent job text log file to the Linux NFS share. I successfully upgraded the VM to SQL Server 2025 CU2.β¦
Reinstallation doubt regarding Microsoft Visual C++ 2017 distributable package error
can we resolve this SQL Server 2019 install warning - Microsoft Visual C++ 2017 distributable package error, by re-installing the Microsoft Visual C++ 2017 distributable package, if the current windows version already got end of support?
I'm trying to restore sql instance that is about 100gb and there is this issue of limited
I'm not export, I know basics how to do in via SQL Management Studio and I get this message: Microsoft.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit ofβ¦
Does UPDATE WITH (ROWLOCK) guarantee row-level locking, or can SQL Server still acquire page/table locks and perform lock escalation?
Hi Team, I would like clarification on SQL Server locking behavior for an UPDATE statement when the ROWLOCK table hint is explicitly specified. Example: From Microsoft documentation, I understand that: ROWLOCK is a table hint that requests row-levelβ¦
maxdop of a query will fallback to serial or not.
if a query has maxdop 2 : in this case can microsoft decided in this situation to not to use parallelism and use all cores/or execute a query serially, as if parllelism is switched off
Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager
Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually aβ¦
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 2022 Oops... Error decompressing SQL Server media
Hello, I am trying to install SQL Server 2022 for the first time, but it gives me this error. I spent about 10 days to find the main cause of this problem and try to solve it, but it seems that is a new one. I tried to: remove .exe installation fileβ¦
How to find the installation file for an older version of SQL Server Migration Assistant?
I need to migrate an Oracle database to SQL Server, but the current Oracle version is 11g, which is not supported by the latest version of SSMA for Oracle. How can I install a version of SQL Server Migration Assistant that supports Oracle 11g? SSMA forβ¦
How to find the previous versions of SSMA for Oracle
Hi Team , Can you please let us know how to find the previous version of SSMA ? Thanks! Seshu
SQL Agent job step "Dump on errors" produces no output
I have a SQL Server Integration Services Package agent job step that is failing with an "Unexpected termination". To help diagnose what's going on, I've selected the "Dump on errors" flag of the Configuration/Advanced tab. Howeverβ¦
Official Download Link for MS SSMS v20.2.1
Hello Everyone, I am trying to upgrade my existing MS SSMS from v18.12.1 to v20.2.1 in one of my environments. I am looking for the installer, but I could not find one from the Microsoft Official website. This page of 20.2.1 takes me to the download ofβ¦
An error occurred during the execution of DDL with variables while migrating the database using CDC.
We are performing a database migration for a SQL Server upgrade. After enabling CDC in SQL Server 2016, an error occurred in the SQL query for rebuilding an index with a variable, called by the database maintenance batch. Must declare the scalarβ¦
Running total for grouped data
Given input data similar to: Month Region Store Sales Jan R1 S1 10.00 Jan R1 S1 15.00 Jan R1 S1 30.00 Jan R1 S2 5.00 Jan R1 S2 1.00 Jan R2 S3 17.00 Jan R2 S3 β¦
How to install SQL Server Management Studio for Personal Use
Hello, I would like to download the latest SQL Server Management Studio locally on my machine for personal use and training. I have been unemployed since Nov-2025 and I would like to maintain and increase my SQL skills. I would also like some basicβ¦
auto send a report daily
how to have a report auto generate to a pdf and emailed to me and the other advisers, every morning. report in question is the "Service Adviser Performance" report for store 2115, Mercedes Benz of North Orlando.
Quiero descargar SMSS
ΒΏCΓ³mo descargo SSMS, estuve intentando y no me deja, ademΓ‘s no me aparece la opciΓ³n de: "Descarga de SMSS"?
SQL vs NoSQL Databases: Key Differences and Use Cases
What is the difference between SQL and NoSQL databases, and when would you choose each?
Upgrading SQL 2019 to 2025 - Fulltext index issue
When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade. It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder,β¦
Power BI Desktop "Cannot establish connection" - msmdsrv.exe listening but connection timeout
Hello, I'm experiencing a persistent issue with Power BI Desktop failing to start. The error message is: "Cannot establish connection. Please verify that the server is running." Environment OS: Windows 11 Pro (10.0.26200) Hardware: Intelβ¦