21,505 questions with SQL Server-related tags

Sort by: Updated
3 answers

changing the endcoding of an attached file in sql trasaction

Hi, I have written a sql server procedure which sends the result of a query as a csv file via e-mail. SQL server generates the attached file in UTF-8 BOM encoding. I need the attached file to be generated in UTF-8 (without BOM). I tried to…

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,715 questions
SQL Server | Other
asked 2021-07-02T10:37:55.837+00:00
Massimo 1 Reputation point
commented 2026-03-30T23:28:28.8866667+00:00
Beemer Guy 0 Reputation points
0 answers

Using SSMA v10.0 on AzureSQL Managed Instance

I'm trying to use SQL Server Migration Assistant for Sybase, to migrate to an Azure managed instance. However, when I try to connect to the AzureSQL database, SSMS apparently tries to do a cross-database query, and gets the error: One of the internal SQL…

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

606 questions
asked 2026-03-30T22:06:22.4033333+00:00
Hansen, David-E 0 Reputation points
edited the question 2026-03-30T22:11:11.8966667+00:00
Hansen, David-E 0 Reputation points
1 answer

SQL Server Backup and Restore select transfer sizes to s3

Hello, I am trying to calculate how much RAM I would need for backups of a big database to s3, where I have stripes (multiple backup files). I have tried to find the default values fr the operation and i see that the MAXTRANSFERSIZE IS 10MB, but I…

SQL Server | Other
asked 2026-03-30T13:22:08.3533333+00:00
Duygu Hasan 20 Reputation points
answered 2026-03-30T14:52:33.5066667+00:00
Marcin Policht 83,505 Reputation points MVP Volunteer Moderator
2 answers

Act! V22: Windows 11 preventing installation of ACT! V22because of SQL and Shell issues. Help?

I have ACT! v22 which is on a Desktop and a Laptop. Both have Windows 11 and work fine. I just purchased a new laptop and I cannot get ACT! V22 to install. The error message is related to Windows 11 not allowing SQL 2014 and Shell 2 (I believe) to…

SQL Server | Other
asked 2026-03-20T22:32:03.4466667+00:00
David Shear 0 Reputation points
commented 2026-03-30T11:22:38.1933333+00:00
Lakshmi Narayana Garikapati 1,150 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2026-03-25T08:02:31.93+00:00
Suresh Sukumaran 20 Reputation points
commented 2026-03-30T08:54:27.0366667+00:00
Suresh Sukumaran 20 Reputation points
2 answers One of the answers was accepted by the question author.

Missing Columns in sys.dm_tran_persistent_version_store_stats in on-prem SQL Server 2025 and SQL Server 2022

I am unable to find the columns listed below (except database_id and database_name) in on-prem SQL Server 2025 and SQL Server 2022. What is the alternative way to retrieve this information, or are there equivalent columns/DMVs that should be used…

SQL Server | Other
asked 2026-03-26T13:43:23.3333333+00:00
ALAGARSAMY SUNDARARAJAN 0 Reputation points
accepted 2026-03-30T07:47:17.7933333+00:00
ALAGARSAMY SUNDARARAJAN 0 Reputation points
1 answer

Upgrade from SQL Server 2022 Developer to SQL Server 2025 Standard Developer

Hello there, i have question about upgrade Scenario - Upgrade from SQL Server 2022 Developer Edition into SQL Server 2025 Standard Edition. In Documentation is mentioned this path is supported, but SQL Server 2025 Standard Developer Installer dont allow…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,781 questions
asked 2026-03-25T14:39:28.6+00:00
Dan Koci 0 Reputation points
commented 2026-03-30T07:30:49.7166667+00:00
Lakshmi Narayana Garikapati 1,150 Reputation points Microsoft External Staff Moderator
1 answer

How to prove that the purchased SQL is genuine

We purchased an SQL from the distributor. How can we prove that the SQL we bought is genuine and not pirated? If you have any questions, please contact me at the email address <mod: PII removed>@net.

SQL Server | Other
asked 2026-03-18T09:01:30.4866667+00:00
Wali Tai 0 Reputation points
commented 2026-03-30T07:08:58.58+00:00
Lakshmi Narayana Garikapati 1,150 Reputation points Microsoft External Staff Moderator
2 answers

Not able to install Microsoft SQL Express

I have attempted installation multiple times, but it keeps failing. Steps I have already tried: Cleaned up old SQL Server components and services Verified prerequisites (.NET Framework 4.8, Visual C++ Redistributables, Windows updates) Ran installer…

SQL Server Database Engine
asked 2026-03-26T16:15:30.4366667+00:00
Bobbala Anusha 0 Reputation points
answered 2026-03-30T05:20:47.26+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
2 answers

Status of Sql Server replication bug

Hi, A bit over a year ago, I reported a bug in Sql Server replication where columns using different collations than the db default were not replicated properly (in the specific case, the db default was SQL_Latin1_General_CP1_CI_AI and the columns being…

SQL Server Database Engine
asked 2026-03-25T19:01:38.7433333+00:00
Modrall, Mark 15 Reputation points
answered 2026-03-30T03:46:48.5633333+00:00
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator
2 answers

Issues with SQLSetConnectAttr and SQL_ATTR_ENLIST_IN_XA

When using this for implementing an xa-switch for usage with an XATMI product with 2 different thread of controls, the ODBC-driver returns XAER_RMERR in the following scenario Thread A OP_START with TMNOFLAGS Thread A OP_END with TMSUSPEND Thread B…

SQL Server Database Engine
asked 2026-03-26T21:52:19.2733333+00:00
Kristian Ivarsson 0 Reputation points
edited the question 2026-03-29T19:53:28.2266667+00:00
Kristian Ivarsson 0 Reputation points
1 answer

NOT BEING ABLE TO INSTALL SQL SERVER IN MY DEVICE

I can't insatall SQL SERVER 2025 , tried all the version and failed on every please help me !!!

SQL Server | Other
asked 2026-03-29T11:33:41.1366667+00:00
Arpit Sharma 0 Reputation points
answered 2026-03-29T16:11:08.0233333+00:00
Bruce (SqlWork.com) 83,666 Reputation points
1 answer

SQL Server Agent not starting after installing KB5071544

My SQL Server Agent service does not start after a reboot of the server to complete installation of KB5071544. Event logg shows ID 7000, stating timeout occured. I tried increasing the tme out to 5 mins but no change. I am running SQL server 2019…

SQL Server | Other
asked 2025-12-11T19:18:14.1566667+00:00
Abraham Libu Varghese 0 Reputation points
commented 2026-03-29T14:20:48.9933333+00:00
Esteфan L.ON.a ValenzuELa 0 Reputation points
2 answers

Stored Procedure running longer hours

Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…

SQL Server | SQL Server Transact-SQL
asked 2026-03-21T16:55:37.63+00:00
pdsqsql 436 Reputation points
commented 2026-03-29T00:37:49.7266667+00:00
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator
1 answer

What is the proper syntax

Hi, According to the documentation at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver17, I can use the following syntax: ALTER TABLE [draft].[dbo].[temp2] ADD PRIMARY KEY(id) WITH( FILLFACTOR = 20 |…

SQL Server Database Engine
asked 2026-03-27T22:37:37.0366667+00:00
Igor Korot 56 Reputation points
edited a comment 2026-03-28T21:44:25.2466667+00:00
Dan Guzman 9,436 Reputation points
1 answer

Cannot Deploy SSIS project. Error: Could not load type Microsoft.Internal.VisualStudio.Shell.Interop.IVsCustomTelemetryService from assembly Microsoft.Internal.VisualStudio.Interop PublicKey

I get this error trying to deploy a package after installing VS2026 March 2026 release Version 18.4.2. All though it does deploy the error pops up after every step during deployment. I tried a repair, I tried removing the ComponentModelCache folder and…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,781 questions
asked 2026-03-27T13:39:52.1333333+00:00
Barr, David 0 Reputation points
commented 2026-03-27T18:36:55.0166667+00:00
Barr, David 0 Reputation points
2 answers

Install Service Broker External Activator on Windows Data Centre 2022

We are in the process of upgrading from SQL 2017 to SQL 2022. We are having issues installing Service Broker External Activator. I can only find Service Broker External Activator for SQL 2017 but when we go to install we get the error We have checked…

Windows for business | Windows Server | User experience | Other
SQL Server | Other
asked 2025-01-15T15:11:35.0133333+00:00
James Frost 0 Reputation points
answered 2026-03-27T17:18:03.09+00:00
Rob R 0 Reputation points
2 answers

Merge Replication issue with the data type geography

looking for help about our problem in merge replication in sql 2019.

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

606 questions
asked 2022-03-30T09:20:49.327+00:00
Alfie B. Larioza 6 Reputation points
commented 2026-03-27T15:04:10.14+00:00
CAPPELLI Fabio 0 Reputation points
1 answer

What is the latest version of Microsoft report viewer control and is it still supported

I used Microsoft report viewer control winforms in local mode and want to update to the latest supported version. I see there is newer designers for visual studio and nuget packages but there doesn't seem to be any new reportviewer.msi versions for…

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,148 questions
asked 2026-03-27T10:10:02.5533333+00:00
Steven Smart 0 Reputation points
answered 2026-03-27T10:10:16.8933333+00:00
Q&A Assist
2 answers

I can't install SQL SERVER 2025 EXPRESS

Hi. I am trying to install SQL SERVER 2025 EXPRESS in Basic mode . but it keeps failing and giving me this error code. I tried multiple things and finally decided to format my computer.Even that didn' work. Please, if you had this error and know how to…

SQL Server Database Engine
asked 2026-03-21T14:23:01.2433333+00:00
Azra KARAAĞAÇ 0 Reputation points
commented 2026-03-27T07:54:29.9766667+00:00
Azra KARAAĞAÇ 0 Reputation points