549 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

SQL Server 2025 Public Preview Maintenance Wizard plan runtime error

2 issues with Maintenance Plans - for some reason now I cant modify or create any new Maint Plans. Not available and greyed out. When creating any Maintenance wizard plans such as "Misc Cleanup" or DB "Integrity check" scans I am…

SQL Server Database Engine
asked 2025-07-01T20:39:25.7266667+00:00
Shervey, Jeff 1 Reputation point
commented 2025-12-23T22:11:42.1266667+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

DBCC CHECKDB on Secondary Replica

I have an AlwaysOn AG. The secondary replica is set as readable. But, when i run DBCC CHECKDB on secondary replica, it is throwing below error: DBCC CHECK cannot proceed on database because it is a secondary replica and snapshot creation failed.…

SQL Server Database Engine
asked 2025-12-18T12:47:25.15+00:00
Chaitanya Kiran 841 Reputation points
accepted 2025-12-23T20:02:58.7266667+00:00
Chaitanya Kiran 841 Reputation points
2 answers

Linked Server shows local databases rather than Linked Server databases

we cannot get any Linked Server to work using WIA. the Linked Server show the local databases. if we use SQL accounts it works. we don't want to use SQL accounts.

SQL Server Database Engine
asked 2025-10-09T13:24:24.3166667+00:00
Carl94580345 41 Reputation points
recommended 2025-12-23T16:29:38.1166667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server Enterprice y SA

Hola, tengo una duda con el licenciamiento de SQL Server Enterprise en la nube: Compré una licencia de SQL Server Enterprise con Software Assurance (SA). Instalé esa licencia en un servidor windows en la nube (AWS). (aun con SA activo) Ahora mi SA ya…

SQL Server Database Engine
asked 2025-09-26T17:26:41.1066667+00:00
Efren Tello 0 Reputation points
recommended 2025-12-23T16:29:04.4133333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

Hi when I try to install sql server 2022 I'm getting multiple errors

TITLE: Microsoft SQL Server 2022 Setup The following error has occurred: The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error…

SQL Server Database Engine
asked 2025-09-26T16:06:56.4533333+00:00
Ram Kalidasu 0 Reputation points
recommended 2025-12-23T16:28:04.5533333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

Assistance Needed for Rolling Back Specific Transaction from SQL Server Log

Guidance is needed on recovering data from a specific transaction in SQL Server after an unintentional DELETE/UPDATE operation. The database is operating in Full Recovery Model with access to transaction log backups. Understanding that SQL Server doesn't…

SQL Server Database Engine
asked 2025-09-09T12:18:31.7833333+00:00
Rahul Lohar 0 Reputation points
recommended 2025-12-23T16:27:20.1766667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

sql server 2017 merge replication is stuck on stored procedure sp_MSmakegeneration

sql server 2017 merge replication is stuck times out on stored procedure sp_MSmakegeneration how to fix this ?

SQL Server Database Engine
asked 2025-09-24T14:34:29.0066667+00:00
Michael Bohomolec 0 Reputation points
recommended 2025-12-23T16:26:48.09+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

DDL and DML Capture

Hello Community, I am wondering if there's an already established way to track and log all TRUNCATE, INSERTS AND DELETES statements across SQL Server. I already have a DDL trigger process that logs every DDL event on the server, specifically for CREATE,…

SQL Server Database Engine
asked 2025-10-09T10:57:00.12+00:00
Babawale Dawodu 110 Reputation points
commented 2025-12-23T05:08:08.7066667+00:00
Akhil Gajavelly 950 Reputation points Microsoft External Staff Moderator
0 answers

sql server database engine service how can i resolve this in windows 11

i have an issue while installing sql server its showing error databse engine service failed in window 11 and i installing 2025 version of sql server

SQL Server Database Engine
asked 2025-12-22T07:15:13.7133333+00:00
jhasaketan behera 0 Reputation points
commented 2025-12-22T22:36:09.77+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
2 answers

SQL server 2022 remote query timeout

Scenario: HP DL 380 G11 Server Windows Server 2025 Std DC SQL 2022 Std Workstations integrated into the domain with Windows 11 Pro. ODBC Version 18. On the workstations, runs an application that works with a database existing in the single SQL…

SQL Server Database Engine
asked 2025-12-19T17:07:33.1433333+00:00
MadUrantia 85 Reputation points
commented 2025-12-22T22:33:14.8633333+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 Installation Error

SQL Server 2025 Enterprise Developer Edition Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.

SQL Server Database Engine
asked 2025-12-19T13:15:23.24+00:00
Vijoy T Abraham 0 Reputation points
commented 2025-12-22T13:04:43.3033333+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)

Details: I am running Microsoft SQL Server 2022 I am running DBCC CHECKDB on a user database (of which raised this error), each saturday This has happened on one on-prem Windows Server with installation of SQL server, with a predefined set of…

SQL Server Database Engine
asked 2025-05-07T08:39:20.11+00:00
Lucas Bjorndal 0 Reputation points
recommended 2025-12-22T12:17:26.61+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

How to fix this error with rxInstallPackages

I have installed the Machine Learning services on Microsoft SQL Server 2022 (RTM-GDR) (KB5068407) - 16.0.1160.1 (X64) Oct 3 2025 18:06:58 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build…

SQL Server Database Engine
asked 2025-12-16T09:18:18.59+00:00
Stephen Hayes 0 Reputation points
edited a comment 2025-12-22T10:44:56.1033333+00:00
Stephen Hayes 0 Reputation points
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
asked 2025-12-04T05:16:29.8166667+00:00
Pratik Narottam Panchal 0 Reputation points
answered 2025-12-22T10:04:21.6733333+00:00
Pratik Narottam Panchal 0 Reputation points
1 answer

Connection pool error I am getting

Error: operation timed out for an unknown reason    at /node_modules/tarn/dist/PendingOperation.js:14:27 This is the error I am getting when I login to my applicaiton. In very next attempt I am able to login properly. What could be the possible reason…

SQL Server Database Engine
asked 2025-12-18T03:44:01.12+00:00
Dvebrat Tripathi 0 Reputation points
commented 2025-12-22T08:53:14.7833333+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
1 answer

Does SQL server retain the setting for IDENTITY_INSERT after a session closes

I have set IDENTITY_INSERT ON for a table, does that setting remain after the session ends?

SQL Server Database Engine
asked 2025-12-17T08:48:50.45+00:00
MichaelHorwell-4553 0 Reputation points
commented 2025-12-22T08:50:10.3433333+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server Developer

SQL Server Developer Editionについて教えてください。 ライセンスの数量、有償、無償範囲、 Enterprise EditionとDeveloper Edition違い、 Developer Editionの5年稼働における注意点、AWS EC2で利用の注意点、 サポートの違い また、以下の構成でSQLライセンスを購入予定ですが 何か留意点はございますか? 本番用:32 vCPUのEC2 → SQL Server Enterprise Edition…

SQL Server Database Engine
asked 2025-12-15T05:30:07.8033333+00:00
吉田明伸 0 Reputation points
commented 2025-12-22T08:45:33.6066667+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
2 answers

i noticed the sqlhealth extende event is on by default , so can i reduce

hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…

SQL Server Database Engine
asked 2025-12-12T12:06:09.9233333+00:00
Rajesh Kumar Yadav 20 Reputation points
commented 2025-12-22T08:44:22.18+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
3 answers

How to install SQL Server Developer on a Snapdragon Laptop

I got a new Dell laptop that has a Snapdragon processor and am unable to install SQL Server. Is there a procedure for doing this? If the solution is emulation, then is there a procedure for setting up emulation too? Thanks

SQL Server Database Engine
asked 2025-06-17T21:19:04.1466667+00:00
Robert Watson 5 Reputation points
commented 2025-12-22T08:28:00.59+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
3 answers

Help Needed with SQL Server Express Installation

Hi everyone, I’m trying to install SQL Server Express (Basic Edition) on my Windows machine for a Microsoft Windows Object Oriented Programming project, but I keep running into an error. Every time I attempt the installation, I get the following message:…

SQL Server Database Engine
asked 2025-09-28T15:37:25.1366667+00:00
yasinfect 0 Reputation points
recommended 2025-12-22T06:27:50.76+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator