SQL Server

SQL Server 2019 Table lock and wont unlock until restarting database

We are running Microsoft SQL Server 2019 (RTM-CU32-GDR) and a specific database table seems to lock and never unlocks. It also locks all associated tables. The only way to get the database to respond is wait for it to restart or restart the entire SQL…

Can we get the T-SQL debugger back?

How can I browbeat Microsoft to re-enable the debugger in SSMS? I tried using SSDT in Visual Studio 2022, and it was absurd ... I had to spend fifteen minutes creating a new project, importing the database, etc. only to be told, when I started trying to…

AG instance not in sync

We have 8 databases in an instance. All 8 databases are members of Availability Group. On the secondary replica, the whole instance is not synchronizing . Could you please advise how to bring the secondary instance as synchronized Thanks, Chaitanya

Licensing Query: Downgrade Rights clarity on Active SQL Server Subscription purchased via CSP

Hi, I have been trying to get something official reference that explicitly confirms the Downgrade Rights for CSP Subscriptions, specifically as an example: Active subscription purchased via CSP for 'SQL Server Standard 2022 - 2 core license pack - 1…

Sequel Server Reporting Services - are there any wildcard characters that you can use in the filter fields?

In the Sequel Server Reporting Services, are there any wildcard characters that you can use in the filter fields such as a customer name field?

sp_addlinkedsrvlogin with @rmtpassword fails with Msg 7455 after upgrade SQL Server 2022 to 2025

Our product need to create Linked Servers in SQL Server to achieve our function, it works well in SQL Server 2022, but after upgrading to SQL Server 2025, it's always broken, we analyzed and tested with different case, it only broken when calling…

SQL Server 2019 Express installation fails on Windows 11 with SQLWriter service and Windows Installer DLL errors

I am trying to install Microsoft SQL Server 2019 Express on Windows 11 (64-bit). The installation fails with the following errors: Service 'SQL Server VSS Writer' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system…

SQL 2022 Express Replication with error

The error says "The process could not connect to Publisher"

Database for training

Hello, I want to train for data analytics projects w/o AI, does Microsoft provide real databases to work on?

Please advise if the system is down or if there are any reporting of an issue. I am getting this error message below-

Need to request a report from a Small Package customer that is requesting the Entry Summary from past shipments

Hi, I need to know if in SSRS, I can generate a report of the Entre Summary from a Small Package Customer.. See below the type of Image Im looking for.. Could you guide me, on wich report should I select ?

SQL Server Migration Assistant (SSMA) for DB2 v10.5 - crash with "Exception: Win32 handle that was passed to Icon is not valid or is the wrong type."

SQL Server Migration Assistant for DB2 crash. See attached log file.

clone a report

Can I clone a report in ssrs? Need to make a copy of a report where both reports will change when a report is uploaded.

SQL Server Management Studio Connection Issue

I can't establish a connection to SQL Server. I likely need IT Support but am unable to find that support. If you can help me connect, please respond. If all you can do is direct me to a support that can assist me.

I am encountering an issue while installing Microsoft SQL Server 2022 Express Edition. The installation fails with the following error: Product: SQL Server 2022 Express Edition Operating System: Windows (please specify your version) Error Code: -20618936

Cannot Deploy SSIS project. Error: Could not load type Microsoft.Internal.VisualStudio.Shell.Interop.IVsCustomTelemetryService from assembly Microsoft.Internal.VisualStudio.Interop PublicKey

I get this error trying to deploy a package after installing VS2026 March 2026 release Version 18.4.2. All though it does deploy the error pops up after every step during deployment. I tried a repair, I tried removing the ComponentModelCache folder and…

How to install SQL server to my windows 11, Error occurs while I installing

How to install SQL server to my windows 11, Error occurs while I installing Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893607 Start time: 2024-08-29 16:55:33 …

Windows for business | Windows Client for IT Pros | User experience | Other

Windows for business | Windows Client for IT Pros | User experience | Other

29,108 questions

Sign in to follow

SQL Server | Other

SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,778 questions

Sign in to follow

Restore backup in parallel to primary and secondary of availability group with manual seeding

I have SQL Server availability group with manual seeding and two synchronous replicas - primary and secondary. I want to onboard a set of database backups onto the availability group : 1 full backup + 1 transaction log backup. Backups are large, so I…

sqlcmd not recognized - inspite of the fact installed with "winget install sqlcmd

Hi, I have an issue running sqlcmd on a win 10 box. I followed instructions at https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/tools/sqlcmd/sqlcmd-download-install.md I get success message as follows I do a ce to "C:\Program…

if i install sql server 2022 64 bit, will it install and register 32 wmi provider

SQL Server's Configuration Manager WMI provider (sqlmgmprovider.dll): has been a 32-bit-only component. so my ask is if the sql server 2022 64 bit contains 32 wmi provider install and register.