Core component of SQL Server for storing, processing, and securing data
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.…
SQL Server Database Engine
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
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 Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
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…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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 …
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
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…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
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.
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.
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 Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL vs NoSQL Databases: Key Differences and Use Cases
What is the difference between SQL and NoSQL databases, and when would you choose each?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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,…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Download SFTP files using ssis
I have files sitting in an SFTP location and I am trying to bring them to a shared drive using SSIS. The problem with SSIS is that it has a task for FTP but not for SFTP. Here is what I did for now. I created an SSIS Package and used an…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
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…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
SQL Developer license
I would like to request formal clarification regarding the permitted use of SQL Server Developer Edition in a specific customer environment scenario. Context We are designing and operating a non‑production environment with the following…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Can't connect to sql server
I Downloaded SQL and I can't connect to the server.
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data