717 questions with SQL Server Database Engine tags

Sort by: Updated
3 answers

locking issue in MSSQL

Issue: the holdlock script has locking the multi-thread(10) insert/update We would like to revise the multi-thread script to from (HOLDLOCK) to (UPDLOCK, SERIALIZABLE) Original script: MERGE testtable WITH (HOLDLOCK) AS t USING (SELECT @P0 hjmpTS, @P1…

SQL Server Database Engine
asked 2026-05-20T07:28:48.0066667+00:00
Sam Chung 0 Reputation points
recommended 2026-06-04T19:12:33.0966667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Claim space for TempDB on Sql Server

Dear Team, Dose Someone kindly advise how to shrink teamdb with effective way without affect Database Service ?

SQL Server Database Engine
asked 2026-05-06T03:12:42.8866667+00:00
Veasna Lay 0 Reputation points
recommended 2026-06-04T19:10:47.9133333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Sql server 2025 installation error

Hello Microsoft Support Team, I am reaching out regarding an installation issue with Microsoft SQL Server 2025 (Express Edition) on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language (Build 26200). During installation, the server fails…

SQL Server Database Engine
asked 2026-04-20T17:33:12.6733333+00:00
sanjay MN 0 Reputation points
recommended 2026-06-04T19:07:28.67+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server Login Failures (Error 18456) due to Reporting Services attempting to access non-existent ReportServer database

We are experiencing repeated SQL Server login failures (Event ID 18456) on one of our servers. Details: SQL Server Version: SQL Server 2016 Error Message: "Login failed for user 'REA\IND-WBN-DEV$'. Reason: Failed to open the explicitly specified…

SQL Server Database Engine
asked 2026-04-17T07:24:16.13+00:00
Kamarur Rama 0 Reputation points
recommended 2026-06-04T19:07:15.7866667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Unable to install micrsoft sql server

Unable to install sql server, there is some installtion of previous version is present so unable to install microsoft sql server 2019

SQL Server Database Engine
asked 2026-04-13T06:57:25.6866667+00:00
Akshay Hebbar 0 Reputation points
recommended 2026-06-04T19:06:49.3033333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 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
asked 2026-06-04T13:03:09.61+00:00
Mansoor R 0 Reputation points
answered 2026-06-04T18:54:50.8033333+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Logon issue

Hi, Can you help to this? A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to…

SQL Server Database Engine
asked 2026-06-04T09:33:24.9333333+00:00
Jonathan 85 Reputation points
accepted 2026-06-04T09:37:20.71+00:00
Jonathan 85 Reputation points
2 answers

how to open sql server from visual studio

I 'am traying to open the SQL server 2022 folder after installing visual studio 2026 but the folder that I have for SQL server 2022 is empty folder why?

SQL Server Database Engine
asked 2026-05-26T22:09:12.9266667+00:00
elamin osman 0 Reputation points
commented 2026-06-04T07:02:23.0366667+00:00
Lakshmi Narayana Garikapati 1,330 Reputation points Microsoft External Staff Moderator
1 answer

SQL DB not Found

Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…

SQL Server Database Engine
asked 2025-04-28T08:46:47.8233333+00:00
Shabir jan 21 Reputation points
edited a comment 2026-06-04T04:32:44.8833333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
1 answer

Facing an issue while Export/Backup SQL Database

While taking backup of an existing SQL Database using Export Database option, observed that its taking too much times in hours. After 3-4 hrs as well its showing progress of just 1% only. So want support for the same that what could be the reason behind…

SQL Server Database Engine
asked 2025-04-14T10:14:50.65+00:00
Gravitive Service 0 Reputation points
commented 2026-06-04T04:30:08.9633333+00:00
Akhil Gajavelly 1,825 Reputation points Microsoft External Staff Moderator
2 answers

Upgraded sql server from sql 2016 to sql 2022, but master database still at 130 level. Should i change it ?

We upgraded sql server from sql 2016 to sql 2022, but master the database still at 130 compatibility level level. I get why the upgrade process needs to keep the master database at 130 level. Post upgrade, should we manually change the compatibility…

SQL Server Database Engine
asked 2026-06-03T08:08:57.19+00:00
Greg Booth 1,516 Reputation points
answered 2026-06-03T19:11:21.2866667+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
3 answers

The long running select statement blocked the insert/update statement

The long running select statement blocked the insert/update statement execution Scenario:  We have the multi-thread batch insertion logic to insert data to MSSQL database. When the insertion logic was executed, some users execute a long running select…

SQL Server Database Engine
asked 2026-05-08T06:42:51.8466667+00:00
Sam Chung 0 Reputation points
recommended 2026-06-03T05:42:42.3+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2022 Express installation error -2061893606 and service error 1067

Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …

SQL Server Database Engine
asked 2026-05-14T10:18:59.6533333+00:00
Youssef Maach 0 Reputation points
recommended 2026-06-03T05:32:30.5966667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

how to fix physica; sector size when PC has m.2 drives

LargeSectorSizeCheck Checks whether any disk intended for SQL Server data has a physical sector size greater than 4 KB, which is currently unsupported. Warning One or more disks intended for SQL Server data have a physical sector size greater than 4 KB.…

SQL Server Database Engine
asked 2026-05-12T11:49:12.42+00:00
Peterson Gideon 0 Reputation points
recommended 2026-06-03T05:31:50.34+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations

Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…

SQL Server Database Engine
asked 2026-04-24T17:19:09.7+00:00
Uday Paleti 5 Reputation points
recommended 2026-06-03T05:19:03.61+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

Sql Server 2025 Updated Application working Slow

Application have been running really slowly since upgrading the database to SQL Server 2025.

SQL Server Database Engine
asked 2026-05-07T07:36:42.0066667+00:00
Ab Malik 0 Reputation points
recommended 2026-06-03T05:18:23.5666667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

how to sucessfully connect sql Smm server profile to database engine?

i tried connecting sql 2025 model of server profiler 22 in my system of DESKTOP-UL2OACD BUT its showing TITLE: Connect to Server Cannot connect to DESKTOP-UL2OACD\iwunor kelechi. ADDITIONAL INFORMATION: A network-related or instance-specific error…

SQL Server Database Engine
asked 2026-05-02T14:05:18.68+00:00
Iwunor kelechi 0 Reputation points
recommended 2026-06-03T05:17:43.25+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Erro na instalação do SQL Server 2025 express - Exit Code-2061893606

Prezados, Estou enfrentando um problema recorrente ao tentar instalar o Microsoft SQL Server 2025 Express Edition em meu computador com Windows 11. Durante o processo de instalação, o setup falha com a seguinte mensagem: Exit code (Decimal):…

SQL Server Database Engine
asked 2026-04-25T17:49:50.47+00:00
Joao Beluso 0 Reputation points
recommended 2026-06-03T05:16:19.8266667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

POC: Best approach to automate DB Query Stress Testing in CI/CD Pipeline for .NET Core + SQL Server + AKS?

Hi Community, We are planning a POC to automate database query stress and load testing integrated into our CI/CD workflow. Looking for guidance on tools, patterns, and real-world experience. Our Tech Stack: Backend: .NET / .NET Core Web API …

SQL Server Database Engine
asked 2026-04-17T16:07:06.1566667+00:00
Sikdar, Sameer 0 Reputation points
recommended 2026-06-03T05:12:08.6066667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server Always on AG group failing to failover to secondary

We are experiencing SQL Server Availability Group failover issues. The same problem is occurring across multiple Availability Groups on the same server. We identified that the ODBC drivers were uninstalled and have since reinstalled the drivers and…

SQL Server Database Engine
asked 2026-04-14T10:43:25.8733333+00:00
Narasimha Gopavarapu 0 Reputation points
recommended 2026-06-03T05:11:48.02+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator