21,805 questions with SQL Server-related tags

Sort by: Updated
1 answer

Replication

Im seeking some help. Im trying to do a replication from a main to secondary server. This is well. After I insert records to the tables in the DB here then do another replication back to main from secondary, The records are replicated back but the main…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-10-01T08:11:02.2566667+00:00
rhu rhu 0 Reputation points
commented 2026-10-02T02:24:01.47+00:00
Deepesh Dhake 1,245 Reputation points
1 answer One of the answers was accepted by the question author.

No puedo instalar ninguna versión de SQL server 2022

Me aparece el mismo error en Dev edition y en Eva Edition Ya intenté ejecutar como administrador y sigue igual :/

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-10-01T08:01:11.8266667+00:00
DANIEL CABRERA 20 Reputation points
accepted 2026-10-02T00:49:48.8433333+00:00
DANIEL CABRERA 20 Reputation points
1 answer

SQL Server 2022 Always On metadata calls slow after patching

Following recent patching of our on-premises SQL Server 2022 environment, transaction log backups have become significantly slower than before the patch.   The servers are configured with SQL Server Always On Availability Groups. The issue affects…

SQL Server Database Engine
asked 2026-10-01T15:56:58.9866667+00:00
Jagadeesh Vadivel 0 Reputation points
answered 2026-10-01T20:20:21.1866667+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2022 performance degradation (2x slower) with increased Context Switches/sec under Compatibility Level 110 after migration

Hi, Please note that this message was translated using Generative AI. I apologize in advance for any unnatural phrasing or translation errors. We recently migrated our database from SQL Server 2017 to SQL Server 2022 on a new virtual machine. After the…

SQL Server Database Engine
asked 2026-09-30T14:42:05.9633333+00:00
k.a 0 Reputation points
commented 2026-10-01T19:31:31.18+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
3 answers

Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?

Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…

SQL Server Database Engine
asked 2025-06-12T12:44:51.11+00:00
Sebastien Flaesch 51 Reputation points
commented 2026-10-01T19:16:46.27+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
2 answers

firewall rule preventing user login

I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…

SQL Server Database Engine
asked 2026-09-30T16:28:53.53+00:00
orville wright 0 Reputation points
answered 2026-10-01T12:34:32.6033333+00:00
Maksood Ahmed 10 Reputation points Microsoft External Staff Moderator
3 answers

Can the date format in SQL Server 2022 Agent notification emails be changed?

SQL Server Agent’s standard notification emails on several SQL Server 2022 instances display timestamps in US format:9/30/2026 at 10:15:54 AM Windows regional settings and the SQL Server Agent service-account profile are configured for English (United…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-30T13:04:01.6066667+00:00
Ananthu GP 5 Reputation points
commented 2026-10-01T08:30:56.2033333+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
1 answer

SQL 2016 to 2022 AG migration on Azure VMs: how to keep the existing DNN listener name working for apps that cache DNS and can't be restarted?

Environment Source: 2-node SQL Server 2016 AG on Azure VMs, using a DNN listener Target: new 2-node SQL Server 2022 AG on Azure VMs, Database: about 4 TB, to be migrated using a distributed AG Clients: many applications and reports that use the…

SQL Server Database Engine
asked 2026-09-30T23:26:27.3066667+00:00
Abimbola Adeniran 106 Reputation points
commented 2026-10-01T07:31:20.51+00:00
Senthil kumar 2,500 Reputation points
1 answer

Geography STDistance() and ShortestLineTo() overestimate polygon-to-polygon distance in SRID 104001 (unit sphere)

(Microsoft SQL Server 2022) In SRID 104001 (unit sphere), STDistance() between two non-intersecting polygons returns values that are too large. In the cases tested, the error was up to about 63 km (converted with R = 6371 km) for polygons 200–500 km…

SQL Server Database Engine
asked 2026-09-30T21:14:29.73+00:00
KoizumiJunko-6191 0 Reputation points
answered 2026-09-30T21:59:37.57+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
1 answer

KB5126149 cause SnowFlakeID broken in MS SQL Server

Below windows update package caused SnowFlakeID broken in MS SQL SERVER, this issue is very serious, caused all transactions cannot record, below are the KB and mapping windows version: OS .NET Update KB Vulnerabilities Addressed Win11 24H2 / 25H2…

SQL Server | SQL Server Transact-SQL
asked 2026-09-18T08:22:44.49+00:00
Water Yue 0 Reputation points
edited a comment 2026-09-30T20:46:35.39+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

SQL SERVER SUPPORT

How can I get sql server support from microsoft?

SQL Server Integration Services
SQL Server Integration Services

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

2,805 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2023-09-26T00:03:22.7533333+00:00
R.B.V 100 Reputation points
answered 2026-09-30T15:02:12.94+00:00
Tejesh Gour 0 Reputation points
1 answer One of the answers was accepted by the question author.

Fabric Lakehouse: T-SQL write support, Spark vs T-SQL performance, and views in semantic models

Can T-SQL notebooks write to a Fabric Lakehouse, or is write capability limited to a Fabric Warehouse? If limited, is that a Lakehouse architecture constraint or a T-SQL constraint? For large-scale data engineering and transformation, does Spark SQL…

SQL Server | SQL Server Transact-SQL
asked 2026-09-29T21:47:06.55+00:00
Anon 20 Reputation points
accepted 2026-09-29T22:50:58.46+00:00
Anon 20 Reputation points
2 answers

SQL Server 2025 Enterprise – Do I need additional core licenses to run Power BI Report Server on a separate server/VM?

Hello, We are planning to purchase Microsoft SQL Server 2025 Enterprise Edition and would like to use the Power BI Report Server (PBIRS) rights included with the SQL Server 2025 license. Our planned deployment is: Server A: SQL Server 2025 Enterprise…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-29T09:55:07.5866667+00:00
Nutpapon Limsupavanich 20 Reputation points
answered 2026-09-29T14:55:24.1333333+00:00
Bruce (SqlWork.com) 85,456 Reputation points
4 answers One of the answers was accepted by the question author.

Need to delete Millions of records from table which is part of Transaction Replication

I have transaction replication on a table. I have to delete millions of records from it. I want to create a SP to delete rows & replicate execution of SP. A few records mismatch might be there between Publisher & Subscriber. Will it cause issue.…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-21T19:27:54.4666667+00:00
Sowjanya Gopal 120 Reputation points
commented 2026-09-29T07:18:20.9033333+00:00
Sowjanya Gopal 120 Reputation points
2 answers

how to Configure or Set query execution timeout from transact SQL

my execution timeout is always show 90, but i need to set it 0

SQL Server | SQL Server Transact-SQL
asked 2026-09-26T10:00:58.6533333+00:00
Jahangir Hossen, Unit Head 0 Reputation points
answered 2026-09-28T13:38:02.9133333+00:00
Deepesh Dhake 1,245 Reputation points
2 answers

Master Data Services web app renders empty after SQL Server CU26 update

Hi everyone, SQL Server 2022 CU26 appears to break Master Data Services web application. After patching to CU26 (16.0.4265.3), the MDS web application loads, but is completely empty. The MDS database and data remain intact and are visible through SQL…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-03T11:43:17.93+00:00
Simon Lenk 10 Reputation points
answered 2026-09-28T07:41:03.4066667+00:00
Peter Nagy 0 Reputation points
2 answers

SQL Server 2022 MDS not showing data on portal after update

Hi After installing an updates on SQL Server 2022 i have problem with MDS. When i go to website and open a model I do not see data in it. Data are avaiable in views and by Excel addin. Is this some bug or I could have broke sth? Daniel

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-08-28T09:36:30.6566667+00:00
Stawik 0 Reputation points
answered 2026-09-28T07:37:12.9566667+00:00
Peter Nagy 0 Reputation points
0 answers

How to Export Text file without CRLF on very last data record

I have a data-driven subscription that writes a text file to a shared file area. Everything is fine. However, I added custom code in VB to see if I could strip the very last CRLF at the end of the file (EOF). The report ran, but it didn't remove CRLF. I…

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,184 questions
asked 2026-09-24T00:59:05.8833333+00:00
Corey Fleig 535 Reputation points
3 answers

SQL Server patching and Windows Server security patching

Could you please confirm whether SQL Server patching and Windows Server security patching can be performed during the same maintenance window, followed by a single reboot? Is this the recommended approach?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-25T06:15:57.5133333+00:00
Kumar Surendran, Sudhin 0 Reputation points
answered 2026-09-27T18:37:33.19+00:00
Adam J. Marshall 11,031 Reputation points MVP
1 answer

SQL Server 2022 Express download page (ID 104781) returns 404 – Is SQL Server 2022 Express still available?

Hello, We are trying to obtain the official installation media for Microsoft SQL Server 2022 Express, but we have found that the historical Microsoft Download Center page associated with SQL Server 2022 Express (Download ID 104781) is currently returning…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,816 questions
asked 2026-09-25T20:45:35.3533333+00:00
Marc Castillo 0 Reputation points
edited the question 2026-09-25T23:51:06.41+00:00
Marc Castillo 0 Reputation points