SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
3 answers
One of the answers was accepted by the question author.
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
asked 2026-06-11T11:41:06.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 65%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bertellini, Luca
0
Reputation points
commented 2026-06-11T22:48:17.38+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
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
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-06-11T15:39:08.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 79%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vinith Ankam
0
Reputation points
commented 2026-06-11T22:42:29.04+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
Can't connect to sql server
I Downloaded SQL and I can't connect to the server.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2025-11-05T03:06:24.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Luisa Jones
0
Reputation points
commented 2026-06-11T19:58:02.05+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
1 answer
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
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-06-11T18:57:56.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
256
Reputation points
edited the question 2026-06-11T19:53:57.61+00:00
Peter Bishop
256
Reputation points
2 answers
Asset KPI's didnt calculated
Some of the asset KPI's can not be calculated, help me find the problem and solution
SQL Server Reporting Services
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.
3,163 questions
asked 2026-05-28T01:34:07.9833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 73%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Fakhrudin Ahmad
0
Reputation points
recommended 2026-06-11T19:46:04.45+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
1 answer
# SQL Server 2022 Availability Group works in Workgroup but fails in Active Directory environment Hello everyone, I am currently learning SQL Server administration and I am doing a practical lab as part of my internship. I would appreciate some guidance
Hello everyone, This is my first time posting on this forum, so please excuse me if I miss any forum conventions or provide too much or too little information. I am currently learning SQL Server administration and I am doing a practical lab as part of my…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,749 questions
asked 2026-06-03T15:26:53.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eurly Garcia LOUP LOCKO
0
Reputation points
commented 2026-06-11T06:43:30.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
1 answer
Derived column truncation error
I am getting following truncation error message in the derived column transformation: The "Derived Column" failed because truncation occurred, and the truncation row disposition on "Derived Column.Outputs[Derived Column…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,795 questions
asked 2026-06-03T03:55:34.95+00:00
Ali Ahad
151
Reputation points
commented 2026-06-11T06:41:13.96+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
2 answers
MSSQL prefer way to transfer big file from server to client.
Hello I have a cpp client which connects to MSSQL server 2025 using ODBC or Native client. I need to transfer large number of files (can vary from 100 MB to 1GB there can be many files from 1 to 100) what is best way to transfer such large amount of data…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2026-05-29T09:44:03.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 19%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vivek Mendse (vmendse)
0
Reputation points
commented 2026-06-11T06:35:53.7566667+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
1 answer
set date range to all records on dates parameters
I want to set my date range in parameters to all dates. how can I do that in parameters settings
SQL Server Reporting Services
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.
3,163 questions
asked 2026-05-28T19:10:12.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 24%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
Victor Hache
0
Reputation points
commented 2026-06-11T06:32:14.2466667+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
2 answers
Test connection failed because of an error in initializing provider. The given key was not present in the dictionary.
I am getting this error VS2022 and VS2026 when tried to create a connection from ssis project with connection manager. SQL server version is Microsoft SQL Server 2022 (RTM-GDR) (KB5073031) - 16.0.1165.1 (X64) Nov 24 2025 19:08:45. It was working…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,795 questions
asked 2026-06-05T12:17:08.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 49%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SB
5
Reputation points
commented 2026-06-11T05:26:11.6366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,330
Reputation points Microsoft External Staff
Moderator
2 answers
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
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-06-10T20:59:13.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Luigi Vitale
0
Reputation points
edited an answer 2026-06-10T21:25:50.6466667+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
1 answer
Performance Degradation after moving from SQL 2019 to SQL 2025
I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2026-05-07T17:39:23.1566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mantini, Ronald M
6
Reputation points
commented 2026-06-10T20:06:09.6266667+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
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
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,749 questions
asked 2026-06-03T07:09:59.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
Yunus Emre Coşkun
0
Reputation points
edited a comment 2026-06-10T12:58:58.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Senthil kumar
660
Reputation points
2 answers
Symmetric key alter issue in SQL Server 2025
Context: I am using SQL Server 2025 with symmetric keys protected by a certificate, and I encrypt/decrypt data using the EncryptByKey and DecryptByKey functions. I now need to migrate the symmetric key protection to Azure Key Vault. However, while…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2026-06-01T14:17:15.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 30%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dipak Nile
0
Reputation points
commented 2026-06-10T07:42:36.7633333+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer Moderator
2 answers
Unable install MSSQL ODBC Driver on the PPC64le
Dear Microsoft support, is there in near future planned to develop MSSQL ODBC driver for PPC64le architecture? From accessible documentation is not available/supported from your side at this moment. Thank you for response. Br, Erik
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2026-05-27T10:13:52.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Erik Tkac
0
Reputation points
commented 2026-06-10T06:48:52.4433333+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
3 answers
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 Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
asked 2026-05-26T06:58:27.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lackner, Mario
0
Reputation points
commented 2026-06-10T06:39:34.5433333+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
4 answers
Prevent a thick-client app's Windows user from accessing the local SQL Express DB outside the app
Setup: A Windows desktop app runs on non-admin workstations. It uses a local SQL Server Express instance on the same machine over shared memory. The app connects to SQL using the logged-in Windows user's own identity (the app process runs as that…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
719 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
2 answers
A script transformation in SSIS 2016 doesn't upgrade to SSIS 2022
Hi All, I created an SSIS 2016 ETL. The ETL has a script transformation in a data flow. Merged the ETL with the SSIS 2022 solution. Upgraded the ETL to 2022 in Visual Studio 2022. Reviewed the upgrade report: ========== The Upgrade is Successful …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,795 questions
asked 2026-06-03T20:17:02.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 92%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Igor Gelin
0
Reputation points
commented 2026-06-10T05:25:29.76+00:00
Lakshmi Narayana Garikapati
1,330
Reputation points Microsoft External Staff
Moderator
2 answers
What is SQL error ID 8179 and how to fix it?
The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV. It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”). This issue often occurs when…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
286 questions
asked 2026-02-18T02:58:30.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Chirayu Traihirun
0
Reputation points
commented 2026-06-10T04:51:14.0866667+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
1 answer
Create Crystal report error in Programs files folder .
I have a Crystal report which is having a data source from MS SQL server. I am always getting this error when we want to show the report: Unknown Query Engine Error Error in File C:\Users\ADMINI~1\AppData\Local\Temp\Test.rpt: Unknown Query Engine…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,749 questions
asked 2025-02-10T13:13:27.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Eduard Kenin
0
Reputation points
commented 2026-06-10T04:42:32.2366667+00:00
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator