SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
1 answer
SQL Server Non Clustered Index CREATE taking forever to cancel
I ran a CREATE NON CLUSTERED INDEX command for 1.5 hours. Decided to cancel it because it was stopping other things running. The command has now been running for 22 hours. What is it doing that takes so long to roll back? The table is 2 billion rows and…
asked 2024-05-23T00:03:03.8166667+00:00
Nick Ryan
221
Reputation points
commented 2024-05-23T21:24:38.4866667+00:00
Erland Sommarskog
102.3K
Reputation points
1 answer
SSRS 2022 upgrade breaks report
After upgrading my SSRS 2022 instances from 16.0.1113.11 to 16.0.1115.61, my reports that usually displays a few columns coming from a stored procedure does not display the results anymore (only lines with blank data in all differents browser). ->…
asked 2024-04-08T16:08:21.4866667+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, 87%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Rives, Vincent
1
Reputation point
commented 2024-05-23T20:45:02.8333333+00:00
Rives, Vincent
1
Reputation point
7 answers
One of the answers was accepted by the question author.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,226 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,700 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR
125
Reputation points
commented 2024-05-23T19:53:28.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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,206
Reputation points
4 answers
Security update for SQL Server 2019 CU25
Hi, I would like to clear up some confusion regarding security updates for SQL Server 2019. If Security update for SQL Server 2019 CU 25 KB5036335 is pushed out by our System Engineers team to a server, does that mean it includes the Cumulative Update…
asked 2024-05-14T17:31:21.2833333+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(83.2, 89%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
David D. Lengar
0
Reputation points
commented 2024-05-23T18:33:36.5566667+00:00
Azar
20,190
Reputation points
2 answers
One of the answers was accepted by the question author.
How to open SQL 2008 SSIS Packages
Hi All, We have SQL 2008 R2 server with integration services and some packages, please let me know how to open the old packages and view it. What tool i need to install to view those files?
asked 2024-05-22T05:56:27.35+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(259.20000000000005, 57.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Karthikeyan Chinnusamy
61
Reputation points
commented 2024-05-23T12:44:52.3633333+00:00
Karthikeyan Chinnusamy
61
Reputation points
3 answers
How to parse SOAP XML in SQL Server and show as table
DECLARE @xml XML ='<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header /> soapenv:Body <ns0:GetListResponse xmlns:ns0="urn:Consultaurartmasiva1"…
asked 2024-05-23T02:00:53.51+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, 83%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
diego diaz
1
Reputation point
edited an answer 2024-05-23T10:26:02.87+00:00
Yitzhak Khabinsky
25,206
Reputation points
1 answer
One of the answers was accepted by the question author.
REST API to get microsoft sql server version history
Is there any REST API to get all the Service Packs and respective latest cumulative packs for each SP of SQL Server Version? expected results should be somewhere near around the table in this doc:…
asked 2021-03-23T11:42:01.693+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(307.2, 48%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
nikhith birru
21
Reputation points
commented 2024-05-23T10:19:13.36+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(96, 73%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dave Gray
581
Reputation points
2 answers
How to install SQL Server in windows 11? I'm getting error code : 2061893606 while installing.
Could you plz help me with this error. how to fix it..?
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,252 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-17T09:19:18.6133333+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(150.4, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Podhari Arun Kumar
0
Reputation points
commented 2024-05-23T09:24:12.3233333+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
asked 2024-05-16T18:33:09.84+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(67.2, 70%, 16%)' 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)
sherif samy
0
Reputation points
commented 2024-05-23T09:23:59.8166667+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
0 answers
mssql server terminated abruptly
Details to log to Microsoft our production mssql data node 01 did a failover to node 02 due to the trigger pt below. Require MSFT advice on why does the DLL below trigger the failover, and how can we prevent this from happening again ? Tech Stack OS :…
asked 2024-05-16T09:19:10.06+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(144, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tan, Wilson WY
0
Reputation points
commented 2024-05-23T09:23:39.91+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
2 answers
I have a problem with the SQL server. The connection is disconnected. Sometimes I looked in the events. The code prints event 17886.
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="MSSQLSERVER" /> <EventID Qualifiers="49152">17886</EventID> …
asked 2024-05-14T06:51:54.7566667+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(281.6, 22%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
saleh ahmed
0
Reputation points
commented 2024-05-23T09:23:27.2166667+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
3 answers
SSMS install errors with incorrect error message while SSMS still running
I ran the 20.1 SSMS installer today, while SSMS was running, and it spat out "Something is blocking the install" but then underneath that was no explanation as to SSMS being running, but rather a funny message about my OS being unsupported…
asked 2024-05-09T04:21:06.5733333+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(89.60000000000001, 87%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mike Pannekoek
0
Reputation points
commented 2024-05-23T09:22:00.61+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
1 answer
The target principal name is incorrect
Hi Team, I've got the error "The target principal name is incorrect. Cannot generate SSPI context" when I tried to connect to SQL Server from other server. I've checked sql logs and I found info SPN was registered . I've run Kerberos…
asked 2024-05-06T13:06:14.6233333+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(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marcin Woszczyna
0
Reputation points
answered 2024-05-23T09:21:21.2566667+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
2 answers
We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work
Hi We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work. We have come across documention which says its has limitations onwiht regards to publisher/subscriber and…
asked 2024-05-15T17:41:11.7933333+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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
40
Reputation points
commented 2024-05-23T09:16:16.2933333+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
1 answer
Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server
In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…
asked 2024-04-24T13:45:40.7233333+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(262.40000000000003, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
ylycfj88
10
Reputation points
commented 2024-05-23T08:45:47.8466667+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(304, 99%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Eswar Chitirala
0
Reputation points
0 answers
Connection failed
Spark job failed: { "text/plain":…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,226 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,017 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-23T06:30:07.4366667+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(48, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Rohith Vinnakota (Quadrant Technologies)
0
Reputation points
commented 2024-05-23T08:30:36.7766667+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, 4%, 31%)' 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)
ShaktiSingh-MSFT
13,996
Reputation points Microsoft Employee
1 answer
客户端与服务端sql server交互问题
问题背景： 一款系统产品的部署测试，SQL Server版本SQLServer2016SP2-FullSlipstream-x64-CHS（一开始为2017有问题，后降到2016仍有问题），服务器系统Windows Server…
asked 2024-05-17T06:18:32.2966667+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
GUGU GU
0
Reputation points
commented 2024-05-23T08:20:19.97+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
2 answers
Kerberos Delegation with IIS and SQLServer
Hello, I have the following environment: Domain controller DomCtrl Win2016 Delegation in AD: Do not trust this computer for delegation Member server Sqlserver: Win2016 with SQLServer 2019 Delegation in AD: Do not trust this computer for delegation…
asked 2024-05-22T06:09:03.6333333+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(160, 95%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
volkhardv
0
Reputation points
commented 2024-05-23T08:12:27.01+00:00
MikeyQiao-MSFT
655
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
SQL Server 2022 express download problem unable to install SQL Server. Exit code(Decimal): -2061893606
I'm trying to download SQL Server 2022 Express, but it's giving the following error. I checked the log and click the SystemConfigurationCheck_Report I received the warning shown in the image above. Is the download error caused by this? I had already…
asked 2024-05-09T12:23:12.46+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(259.20000000000005, 4%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mehmed Aras
20
Reputation points
commented 2024-05-23T07:39:18.6866667+00:00
Mehmed Aras
20
Reputation points
3 answers
Failure to use BCP IN to import data into a table
bcp "SELECT * from dp_history21052024 WHERE CONVERT(DATE,effective_dt,103) >'29-Feb-2024'" queryout "D:\Data\Data.csv" -S ORBITLITEDB-SVR -d OrbitLiteLive -U sa -P xxxxxxxx -c -t, -r\n and then the below for import bcp…
asked 2024-05-22T07:15:59.7733333+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(60.8, 35%, 15%)' 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)
Godfrey Mugisa
0
Reputation points
answered 2024-05-23T07:22:37.94+00:00
CosmogHong-MSFT
23,796
Reputation points Microsoft Vendor