683 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

Error Update SQL Sever version

Hi Expert, I'm updating SQL Server 2019 RTM version with Latest Update version but failed that report log message " The NT service 'MsDtsServer150' could not be stopped" what should i do to resolve this error? great thanks for all warm…

SQL Server Database Engine
asked 2026-04-09T10:00:07.8+00:00
Urbel 545 Reputation points
accepted 2026-04-09T10:02:48.2133333+00:00
Urbel 545 Reputation points
4 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
recommended 2026-04-09T04:12:57.2366667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Issues with SQLSetConnectAttr and SQL_ATTR_ENLIST_IN_XA

When using this for implementing an xa-switch for usage with an XATMI product with 2 different thread of controls, the ODBC-driver returns XAER_RMERR in the following scenario Thread A OP_START with TMNOFLAGS Thread A OP_END with TMSUSPEND Thread B…

SQL Server Database Engine
asked 2026-03-26T21:52:19.2733333+00:00
Kristian Ivarsson 0 Reputation points
commented 2026-04-09T03:49:53.8+00:00
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator
2 answers

when is the update to sql server be available to allow vector index with GUID

Trying to use sql server with Vector indexing for tables with GUID keys. We don't use INT for keys. When will updatable guid key tables with Vector indexing be available. Thank you David

SQL Server Database Engine
asked 2026-03-10T13:17:45.1366667+00:00
OnePage 20 Reputation points
edited a comment 2026-04-08T05:50:48.45+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

Connect ssms to sql server

How to connect SSMS to SQL SERVER. New installation of SQL 2025 and ssms.

SQL Server Database Engine
asked 2026-03-10T01:56:57.0366667+00:00
Keith Oliver 0 Reputation points
commented 2026-04-08T05:31:02.16+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

How to change SQL Server Instance from running to start?

I am trying to open PCM600 for writing to relays. When trying to open the pop up that show is PCM600 has encountered a problem. SQL Server instance not found. Verify that SQL Server is installed and running. Not sure what I am supposed to do. I go into…

SQL Server Database Engine
asked 2025-10-28T12:08:30.0033333+00:00
Donald Rutledge [EXT] 0 Reputation points
recommended 2026-04-08T04:51:57.2933333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

HELP! Looking to buy a support incident for SQL Server 2022 running on-premises

The Buy now ($499) workflow at https://support.microsoft.com/en-us/support-for-business does not work. No luck with any of the 1-800 MS numbers either. Can someone help? Many thanks. arky

SQL Server Database Engine
asked 2026-03-31T13:08:43.3033333+00:00
Arky Cunanan 5 Reputation points
answered 2026-04-07T04:28:44.4166667+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer

Error description: Could not find the Database Engine startup handle or Error Code 1639

I feel like ive tried everything, ive even completly reset my pc. I was orginally trying to install SQL Server 2025 Devolper edition but i also tried the 2022 version once and got handle error there as well. My sector size is 4096. I dont have the old…

SQL Server Database Engine
asked 2026-04-02T20:49:47.2166667+00:00
Miller, Madisyn 0 Reputation points
commented 2026-04-07T03:39:09.56+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Install patch SQL server 2016 need restart??

Hi all, Does need restart system after install patch CU or SP ? can it do when SQL Server still active? thank you warm regards, Urbel

SQL Server Database Engine
asked 2026-04-07T03:19:08.76+00:00
Urbel 545 Reputation points
accepted 2026-04-07T03:20:11.8366667+00:00
Urbel 545 Reputation points
1 answer

SQL Server performance (slowness)

Hi, could you please open the ticket for issue recently encountered in our production environment hosted on Nournet Cloud. your support is highly appreciated, Thanks,

SQL Server Database Engine
asked 2026-04-05T06:46:56.8633333+00:00
Muhammad Skaik 0 Reputation points
commented 2026-04-06T09:04:50.05+00:00
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator
2 answers

Sql server 2025 standard version features

Which features we need to select while installing the sql standard 2025 for production environment,For 2019 and 2022 we select all client tools but here we have no clarity, so please suggest as soon as possible

SQL Server Database Engine
asked 2026-03-07T14:43:44.19+00:00
Anandhswarupp 205 Reputation points
commented 2026-04-06T04:19:44.5566667+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer

sql server crashes when restoring a DB

We recently installed sql server 2025 on a linux machine. While trying to restore a DB previously taken from a sql server 2016 system, the new sql server 2025 always crashes.

SQL Server Database Engine
asked 2026-03-04T20:00:51.7633333+00:00
Domouchtsis, Petros 0 Reputation points
commented 2026-04-06T04:10:58.9666667+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Need latest bcp tool for Entra usage (should support -G and -u)

I have tried installating latest SQL Server Tools, MS-ODBC driver, and even SQL Server 2025. But the bcp tool didn't have '-u' option. ODBC v18 doesn't have tools. So it refers to 170 in ODBC.

SQL Server Database Engine
asked 2026-04-05T11:22:54.45+00:00
Rath, Biswaranjan 20 Reputation points
accepted 2026-04-05T14:18:05.7933333+00:00
Rath, Biswaranjan 20 Reputation points
1 answer

uninstall sql 2016 setup

we have done an in place upgrade of sql server from 2016 to 2022. However sql 2016 setup still shows in add remove programs and wont uninstall. How do i remove

SQL Server Database Engine
asked 2026-03-22T20:57:47.9133333+00:00
Greg Booth 1,496 Reputation points
recommended 2026-04-05T11:13:44.2333333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

DB recovery in a semi-annual SQL plan

I accidentally downloaded SQL Server and SSMS to a computer for a half-year plan and suddenly I can't connect to the localhost server because half a year has passed. My problem is that I have a very important DB that I don't have access to now. Is there…

SQL Server Database Engine
asked 2025-10-26T09:55:18.3466667+00:00
זהבה אורן 0 Reputation points
recommended 2026-04-05T11:11:44.5833333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

TLS requirement for SQL Server

Hi Expert, our organization has problem with connectivity intermittent between Client and DB Server and now there is Microsoft recommendation to check as below: Review any custom Cipher suite hardening or Group Policy cinfiguration Ensure TLS 1.2…

SQL Server Database Engine
asked 2026-03-11T02:11:04.39+00:00
Urbel 545 Reputation points
recommended 2026-04-02T09:52:05.66+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

How to identify different compressions

Hi, ALL, This - https://dori-uw-1.kuma-moon.com/en-us/sql/relational-databases/system-catalog-views/sys-partitions-transact-sql?view=sql-server-ver17 indicates that there is only 1 record for both XML and regular partition compression. My question would be -…

SQL Server Database Engine
asked 2026-03-06T06:53:26.0633333+00:00
Igor Korot 56 Reputation points
recommended 2026-04-02T09:48:39.2333333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

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

After upgrading my SQL Server from versions 2014 and 2022 to 2025, the queries have become noticeably slower.

SQL Server Database Engine
asked 2025-11-23T09:59:35.84+00:00
Amin 10 Reputation points
commented 2026-04-01T06:39:42.27+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2022 installation error + Unable to create SQL instance

Hello everyone, I’m facing two different issues with SQL Server 2022 Developer Edition on Windows 11. I tried multiple solutions, but the problems still persist. During the installation, I get the following error message: I have already…

SQL Server Database Engine
asked 2025-11-20T10:35:03.35+00:00
oussema assili 0 Reputation points
commented 2026-04-01T05:50:03.6+00:00
Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Filtering column on Server Audit Specification

Hi All, How to implement column filter on Server or Database Audit specification? I need to exclude [Action ID] SELECT Great thanks for all respond warm regards, UrBel

SQL Server Database Engine
asked 2026-03-31T04:40:45.1333333+00:00
Urbel 545 Reputation points
accepted 2026-03-31T09:32:53.39+00:00
Urbel 545 Reputation points