531 questions
2 answers
Unable to Pull Docker Image for SQL Server
docker pull mcr.microsoft.com/mssql/server Using default tag: latest Error response from daemon: failed to resolve reference "mcr.microsoft.com/mssql/server:latest": failed to do request: Head…
SQL Server Database Engine
asked 2025-05-05T02:53:11.8933333+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, 53%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinod Kumar Nerella
0
Reputation points
commented 2025-12-09T04:25:12.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
875
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server 15.0.2155.2 issue with synonym on scalar value function
Hello there, we noticed a strange issue with SQL Server 15.0.2155.2. We have two main databases on the server. Database A has a scalar value function that regularly gets called from database A and B. We use synonyms to reference the function in database…
SQL Server Database Engine
531 questions
asked 2025-12-08T13:18:48.3566667+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(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Rene W
0
Reputation points
answered 2025-12-08T21:58:14.3333333+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
1 answer
Trouble configuring SQL Server Always On
I have created an AD setup. Joined two sql vms(primary and secondary) into that AD. I have then installed failover clustering on both the sql nodes, and created a cluster. Then I have enabled SQL Server Always On Availability Groups. Next, while…
SQL Server Database Engine
531 questions
asked 2025-12-08T13:21:50.4033333+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(230.39999999999998, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sree Harshita Maddala
0
Reputation points
commented 2025-12-08T21:49:47.07+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
3 answers
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…
SQL Server Database Engine
531 questions
asked 2025-08-13T13:50:03.2533333+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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Alex Kipritsis
1
Reputation point
commented 2025-12-08T21:48:10.7166667+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
4 answers
.NET GC not reclaiming memory after List<T>.Clear() in SQL CLR UDF under load - leads to memory insufficiency in SQL Server
We're running into memory insufficiency issues on SQL Server when using a SQL CLR UDF written in C# targeting .NET Framework 4.8. The function uses a singleton class to cache user session info using a List<T> of structs. Each struct holds…
SQL Server Database Engine
531 questions
asked 2025-07-11T12:07:51.5866667+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(211.20000000000002, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rakesh Kumar
0
Reputation points
recommended 2025-12-08T20:56:20.73+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
1 answer
Transaction Replication - Missing data in Target
Good day Team, Source: SQL Server: DB Version: SQL-2019 CU-19 OS: Windows 2019 Target: SQL Server: DB Version: SQL-2022 OS: Windows 2022 Publisher and Distributor are the same as of Source Server Subscriber is the Target mentioned above.…
SQL Server Database Engine
531 questions
asked 2025-11-06T15:00:40.53+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(220.8, 80%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gladias Mariadoss
0
Reputation points
commented 2025-12-08T13:58:30.1233333+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(310.4, 2%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar
0
Reputation points
1 answer
Changing Custom 445 Port for SQL Log Shipping
Hello team, We have a banking enclosed environment. Here we are planning to install SQL Server 2022 in DC and DR, and then there will be log shipping between DC and DR via shared network drive. Port 445 cannot be provided due to some bank compliance…
SQL Server Database Engine
531 questions
asked 2025-11-04T17:01:27.8033333+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(297.6, 40%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kiran Varekar
20
Reputation points
commented 2025-12-08T13:55:12.2133333+00:00
Anjan Kumar
0
Reputation points
2 answers
Can I install SQL 2008R2 on server with TLS1.2 or higher enabled
Hello, I have a requirement to upgrade SQL 2000 databases. I am thinking to install SQL 2008R2 , restore SQL 2000 backup file on SQL 2008R2, upgrade database ( provided it goes through). If successful, i will upgrade it further to SQL 2016 or SQL 2019,…
SQL Server Database Engine
531 questions
asked 2025-12-02T16:24:47.6533333+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(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mudit Gupta
81
Reputation points
commented 2025-12-08T12:08:39.41+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
645
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server installation fails with error 0x851A001A after removing old instances
Hi, I’m unable to install SQL Server 2025 Express or 2019 Express. The setup fails every time with: Error: Wait on the Database Engine recovery handle failed Exit code: -2061893606 (0x851A001A) Component: SQL Server Database Engine Services The setup…
SQL Server Database Engine
531 questions
asked 2025-12-01T13:58:58.7866667+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(147.20000000000002, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ailin
0
Reputation points
commented 2025-12-08T12:05:59.74+00:00
Lakshmi Narayana Garikapati
645
Reputation points Microsoft External Staff
Moderator
4 answers
SQL Configuration step issue in Ubuntu Instance
While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…
SQL Server Database Engine
531 questions
asked 2025-12-04T05:16:29.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(12.8, 23%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Pratik Narottam Panchal
0
Reputation points
answered 2025-12-08T11:59:25.2166667+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(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
405
Reputation points Microsoft External Staff
Moderator
1 answer
SSMS not showing Attach Database/Locate Database Files Dialog DIR Tree.
I am unable to Attach a Database in SSMS. The Locate Database Files Dialog text is frozen on a USB port folder that no longer exists. Even entering a dummy database file *.mdf, the OK button does not enable. When I tried to repair SSMS, Error message;…
SQL Server Database Engine
531 questions
asked 2025-05-07T12:34:09.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(147.20000000000002, 28.000000000000004%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shane P. Watson
0
Reputation points
commented 2025-12-08T11:53:39.07+00:00
Lakshmi Narayana Garikapati
645
Reputation points Microsoft External Staff
Moderator
2 answers
How to index vector fields for semantic search in sql server azure
CREATE VECTOR INDEX idx_OpenAIEmbedding ON dbo.table_name (OpenAIEmbedding) WITH ( VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension SIMILARITY_FUNCTION = 'COSINE' ); Started executing query at Line 1 Msg 343, Level 15, State 2, Line…
SQL Server Database Engine
531 questions
asked 2025-04-28T14:48:30.7966667+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, 41%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jarle Holt
0
Reputation points
edited the question 2025-12-08T04:46:52.5133333+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(179.20000000000002, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rekha
0
Reputation points Microsoft External Staff
Moderator
2 answers
Wait on the Database Engine recovery handle failed
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2025-12-07 16:55:50 End time: 2025-12-07 16:59:41 Requested action: …
SQL Server Database Engine
531 questions
asked 2025-12-07T11:39:56.8733333+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(108.80000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Zapadiya, Prahlad
0
Reputation points
answered 2025-12-07T19:01:41.9166667+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
2 answers
SQL 2019 AlwaysOn instance - TempDB files out of balance
Hello. I have a 3-node SQL 2019 AlwaysOn cluster which host multiple instance. One instance on primary node has TempDB files wildly out of balance. There are 8 files. TempDev = 14,285 MB. Temp2 - Temp8 = 8 MB each. On the secondary nodes, TempDB…
SQL Server Database Engine
531 questions
asked 2025-12-06T17:45:17.5333333+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(121.6, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cooper, David A. [ISS] (Contractor)
111
Reputation points
answered 2025-12-06T22:36:39.78+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
3 answers
SQL server 2014 for Calypso
I am trying to install SQL server as part of a program package ZEISS Calypso. I get though the install but it fails to start the service. I can not start it manually. I have made sure the TLS 1.2 and the .NET 3.5 are enabled. This is on Windows 10…
SQL Server Database Engine
531 questions
asked 2025-12-04T16:35:45.21+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(6.4, 8%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Jay E Dorminey
0
Reputation points
commented 2025-12-05T18:04:59.81+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
2 answers
DB STARTUP events in AG replica SQL error log
HI Team, we got an Availability group with 4 nodes (1 primary, 2 synch nodes, 1 asynch node). in the secondary replica sql error logs I see frequent messages as below for various secondary databases. Example: Buffer Pool scan took 11 seconds: database…
SQL Server Database Engine
531 questions
asked 2025-11-16T22:59:43.8533333+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
subhash-DBA
155
Reputation points
commented 2025-12-05T12:16:04.79+00:00
Lakshmi Narayana Garikapati
645
Reputation points Microsoft External Staff
Moderator
2 answers
What happens to my account when the Volume Licensing Service Center (VLSC) is replaced by the Microsoft M365 Admin Center?
ボリューム ライセンス サービス センター(VLSC) からMicrosoft M365 管理センターに変わったため、SQLサーバ2008R2や、2019のボリュームライセンスがダウンロードできない。 弊社のアカウントが現在Microsoft M365と紐づいているが、過去のボリューム ライセンス サービス センター(VLSC) とは結び付いていない。
SQL Server Database Engine
531 questions
asked 2025-12-05T04:57:21.5133333+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(243.2, 94%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
しんどう
0
Reputation points
answered 2025-12-05T10:31:20.8333333+00:00
Lakshmi Narayana Garikapati
645
Reputation points Microsoft External Staff
Moderator
2 answers
Missing Client Protocols in SQL Server Configuration Manager
I installed SQL Server 2025, but when I try to enable TCP/IP from SQL Server Configuration Manager, the Client Protocols field is empty. I've tried everything: uninstalling, reinstalling, checking ports, using snap-ins—I'm at a loss. I have the correct…
SQL Server Database Engine
531 questions
asked 2025-12-03T23:41:08.02+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(70.4, 10%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Serrato, Mario
0
Reputation points
answered 2025-12-04T22:53:41.9466667+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
2 answers
need to kill long running SPIDs
hi, i have seen in my server sometimes some SPIDs get stuck. so we find the logest running SPIDs and kill them . resons are many but in the last i have to kill them. so kindly tel me how to automate this task. on internet some one told me to, use…
SQL Server Database Engine
531 questions
asked 2025-12-04T09:32:47.72+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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
291
Reputation points
answered 2025-12-04T22:48:28.5133333+00:00
Erland Sommarskog
128.7K
Reputation points MVP
Volunteer Moderator
2 answers
Migration of Data
Hello, What is is the best and most efficient (performance wise) method to migrate of full data from large database to small multiple database (microservices) during cutover. Thanks
SQL Server Database Engine
531 questions
asked 2025-06-26T13:22:39.49+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(99.2, 45%, 19%)' 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)
SVA
121
Reputation points
commented 2025-12-04T10:15:09.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(19.2, 28.999999999999996%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Singam shetty Sri ganesh
80
Reputation points Microsoft External Staff
Moderator