626 questions with SQL Server Database Engine tags

Sort by: Updated
2 answers

inc microsoft sql server elevation of privilege vulnerability

(inc microsoft sql server elevation of privilege vulnerability) How to fix it why this vulnerabilities occurred, Latest patch applied on sql instance Recent saw this vulnerabilities on 2017,2019 and 2022 sql instances.

SQL Server Database Engine
asked 2026-02-14T12:18:00.0033333+00:00
Anandhswarupp 205 Reputation points
commented 2026-02-19T09:50:29.1433333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
2 answers

how to resolve degraded sql performance since upgrading from sql 2016 to sql 2022

We have a sql instance ( on premise) that was running sql 2016. Query store was not enabled. We have a large workload that runs overnight, hundreds of stored procedures. We have upgraded to sql 2022, but had an approximately 10% increase of the duration…

SQL Server Database Engine
asked 2026-02-15T23:44:37.3066667+00:00
Greg Booth 1,436 Reputation points
commented 2026-02-19T09:33:53.48+00:00
Greg Booth 1,436 Reputation points
0 answers

CDC change Data Capture on High availibility AlwaysOn 2019

Hello,  I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…

SQL Server Database Engine
asked 2026-02-19T08:29:44.65+00:00
Mona Seddik 20 Reputation points
answered 2026-02-19T08:29:56.36+00:00
Q&A Assist
1 answer

My SQL server exits after running for a few seconds in docker

Hi, I tried running MS SQL server in docker and it exiting withing a few seconds. I am running this on my MAC book. I want to connect Azure data studio to it. Can you please let me know a command that works. I have tried several options and nothing…

SQL Server Database Engine
asked 2026-02-17T17:21:11.53+00:00
LALITHA MARUTHACHALAM 0 Reputation points
edited a comment 2026-02-19T07:06:30.8233333+00:00
Ankit Yadav 11,255 Reputation points Microsoft External Staff Moderator
0 answers

Broken upgrade from SQL Server 2017 to 2022

Hello, SQL Upgrade was started at 2026-02-08 17:52:04. End time was logged as 2026-02-08 17:52:15 with final result "Pending". But in the Detail.txt file I see that last log entry is about 18:10. How can I recognize what is the reason of the…

SQL Server Database Engine
asked 2026-02-17T15:19:23.0733333+00:00
Michał Lis 0 Reputation points
commented 2026-02-19T06:59:17.9433333+00:00
Michał Lis 0 Reputation points
3 answers

STAR Schema Model Design

Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…

SQL Server Database Engine
asked 2026-01-28T02:53:43.0233333+00:00
pdsqsql 436 Reputation points
commented 2026-02-19T05:13:03.15+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
2 answers

STIntersection() hangs forever

Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…

SQL Server Database Engine
asked 2026-02-18T18:14:47.0433333+00:00
MarkusW 0 Reputation points
commented 2026-02-19T02:12:55.9533333+00:00
MarkusW 0 Reputation points
1 answer

Unable to login On-Prem SQL server

Hi Team, We are not able to login On-Prem SQL server. Could you please help with this.

SQL Server Database Engine
asked 2026-02-12T17:23:33.8433333+00:00
Vikash Kumar (HCL Technologies Corporate Services) 0 Reputation points Microsoft External Staff
commented 2026-02-18T10:06:25.9933333+00:00
Akhil Gajavelly 1,165 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Informatica to MS SQL Connections hold locks and block

Informatica to MS SQL Connections hold locks and block

SQL Server Database Engine
asked 2026-02-04T10:41:26.6166667+00:00
Garner, Michael (IT/UK) 20 Reputation points
accepted 2026-02-18T09:12:56.49+00:00
Garner, Michael (IT/UK) 20 Reputation points
1 answer

Database is disappearing

Every time I create a table, it stays for a while (as long as 24 hrs), and I see it gets dropped. I get resource not available. Why am I losing the database?

SQL Server Database Engine
asked 2026-02-18T00:52:58.0866667+00:00
Bhaskar Kumar Chowdhury 0 Reputation points
commented 2026-02-18T07:35:45.6066667+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
0 answers

Why am I getting this exit code 14 error in my project logs?

SQL Server Database Engine
asked 2026-02-09T14:18:18.99+00:00
Raghavendra Katageri 0 Reputation points
commented 2026-02-18T06:57:21.8866667+00:00
Akhil Gajavelly 1,165 Reputation points Microsoft External Staff Moderator
1 answer

How can I enforce and manage transparent data encryption on SQL Databases involved in replication and Always On AGs?

1.. How can I easily manage TDE -particularly where Database restores to lower environments and between servers is required frequently? 2.How can I manage TDE on Source and Target databases where transactional replication is currently setup?

SQL Server Database Engine
asked 2026-02-04T22:53:22.44+00:00
Ogunyemi, Lola 0 Reputation points
commented 2026-02-18T05:48:21.51+00:00
Akhil Gajavelly 1,165 Reputation points Microsoft External Staff Moderator
2 answers

DBF Table named Order in VFP

DBF Table named Order in VFP i think you can't have a tlb named order can anyone help with this problem. Update ORDER ; SET ORDER.GROUP = 'Apples' ; WHERE ORDER.GROUP == 'Apple'

SQL Server Database Engine
asked 2026-02-03T00:46:31.6266667+00:00
Paul Waldner 0 Reputation points
commented 2026-02-18T04:36:14.2133333+00:00
Akhil Gajavelly 1,165 Reputation points Microsoft External Staff Moderator
1 answer

SQL server 2022 installation fails at MOF stage on Windows server 2025 24H2 (26100)

I am trying to install the windows HLK controller + studio on Windows server 2025 24H2 (26100) and failed at SQl installation leading to get to know SQL 2022 server edition installation fails at MOF stage of intallation with error "MOF connection…

SQL Server Database Engine
asked 2026-02-12T08:45:48.5033333+00:00
Rahul K Nair 0 Reputation points
commented 2026-02-17T21:07:51.8066667+00:00
Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator
2 answers

create table script for existing table

I want to create a create table script for existing table with indexes

SQL Server Database Engine
asked 2026-02-08T23:04:04.48+00:00
JOSHI, Vivek 0 Reputation points
commented 2026-02-17T20:38:42.7166667+00:00
JOSHI, Vivek 0 Reputation points
1 answer

What effects does the ARITHABORT setting have on how query plans are created?

Please note I am not looking for advice on how to optimize specific queries. In my SQL Server environment I have come across the all too common "slow in application but fast in SSMS" issue many times. Our application sets ARITHABORT OFF by…

SQL Server Database Engine
asked 2026-02-12T23:21:55.0566667+00:00
Jacob Booher 0 Reputation points
commented 2026-02-17T11:13:28.78+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
1 answer

where can i download sql standard 2022

where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022where can i download sql standard 2022

SQL Server Database Engine
asked 2026-02-12T22:06:22.7933333+00:00
Franklin Husselbee 0 Reputation points
commented 2026-02-17T11:02:18.2533333+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
2 answers

we would like to setup DR nodes for all existing production SQL servers

we would like to setup DR nodes for all existing production SQL servers DR site would be more than 200 miles , what is the best recommendations in terms of network, servers and SQL server editions etc

SQL Server Database Engine
asked 2026-02-12T07:00:00.12+00:00
Sampath Challagonda 0 Reputation points
commented 2026-02-17T10:57:46.95+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft ODBC Driver for SQL Server Version 17.10.000

Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed" Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.

SQL Server Database Engine
asked 2025-08-14T13:52:40.3733333+00:00
Armando D. Hernandez 5 Reputation points
commented 2026-02-17T10:52:29.0466667+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator
1 answer

SQL SERVER (MSSQLSERVER) ERROR 1067

Hola, Tengo un servidor con Windows server 2025 y se le instaló SQL server 2022, se le estaban realizando configuraciones de always on y licenciamiento pero se tuvo que reiniciar. En el momento en que encendió el servidor, el servicio de SQL estaba…

SQL Server Database Engine
asked 2026-02-05T19:14:02.0633333+00:00
jorge miguel callejas quiroga 0 Reputation points
commented 2026-02-17T10:50:48.41+00:00
Lakshmi Narayana Garikapati 825 Reputation points Microsoft External Staff Moderator