SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
1 answer
What is the proper syntax
Hi, According to the documentation at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver17, I can use the following syntax: ALTER TABLE [draft].[dbo].[temp2] ADD PRIMARY KEY(id) WITH( FILLFACTOR = 20 |…
SQL Server Database Engine
asked 2026-03-27T22:37:37.0366667+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
56
Reputation points
commented 2026-03-27T22:46:30.32+00:00
Igor Korot
56
Reputation points
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-26T21:52:19.2733333+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(297.6, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKI%3C/text%3E%3C/svg%3E)
Kristian Ivarsson
0
Reputation points
edited an answer 2026-03-27T08:14:33.07+00:00
Kristian Ivarsson
0
Reputation points
2 answers
I can't install SQL SERVER 2025 EXPRESS
Hi. I am trying to install SQL SERVER 2025 EXPRESS in Basic mode . but it keeps failing and giving me this error code. I tried multiple things and finally decided to format my computer.Even that didn' work. Please, if you had this error and know how to…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-21T14:23:01.2433333+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(118.4, 26%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Azra KARAAĞAÇ
0
Reputation points
commented 2026-03-27T07:54:29.9766667+00:00
Azra KARAAĞAÇ
0
Reputation points
1 answer
Not able to install Microsoft SQL Express
I have attempted installation multiple times, but it keeps failing. Steps I have already tried: Cleaned up old SQL Server components and services Verified prerequisites (.NET Framework 4.8, Visual C++ Redistributables, Windows updates) Ran installer…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-26T16:15:30.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(112.00000000000001, 2%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bobbala Anusha
0
Reputation points
commented 2026-03-26T16:35:45.43+00:00
Viorel
126.8K
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-22T20:57:47.9133333+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(230.39999999999998, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Greg Booth
1,496
Reputation points
commented 2026-03-26T11:43:00.13+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(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
1 answer
Database replication alerts using the SMTP relay Port 25
We tested the TCP connection from the SQL Server to relay.****.com on port 25, and the connection was successful. However, the alert emails are still remaining in an unsent state. Do we need to configure basic authentication while using port 25?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-16T09:17:08.5333333+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(102.4, 68%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Devulacheruvu Venkatesh
0
Reputation points
commented 2026-03-26T11:34:12.8033333+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,150
Reputation points Microsoft External Staff
Moderator
1 answer
How to reset Local Database
My computer is saying local data base must be reset
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-13T14:59:56.87+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(211.20000000000002, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
StorTropolis - Tiffany Springs
0
Reputation points
commented 2026-03-26T11:31:52.1066667+00:00
Lakshmi Narayana Garikapati
1,150
Reputation points Microsoft External Staff
Moderator
1 answer
Status of Sql Server replication bug
Hi, A bit over a year ago, I reported a bug in Sql Server replication where columns using different collations than the db default were not replicated properly (in the specific case, the db default was SQL_Latin1_General_CP1_CI_AI and the columns being…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-25T19:01:38.7433333+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, 16%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Modrall, Mark
15
Reputation points
answered 2026-03-25T19:01:51.34+00:00
Q&A Assist
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-07T14:43:44.19+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(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
205
Reputation points
commented 2026-03-25T10:59:04.82+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,570
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-04T20:00:51.7633333+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(288, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Domouchtsis, Petros
0
Reputation points
commented 2026-03-25T09:06:13.39+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
I am unable to connect on the SQL server
I've already contacted Windows support and they are only have limited resources and only found out the root cause of the issue. They said that the SSMS has an error means that the client tried to establish an encrypted connection, but the SSL cetificate…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-24T07:30:12.73+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(198.4, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sakthi N
0
Reputation points
answered 2026-03-25T06:42:51.5966667+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
Where are the SQL Server developer edition downloads
Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-24T22:21:49.96+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(272, 35%, 36%)' 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)
Steve Margolis
0
Reputation points
answered 2026-03-25T06:12:17.8833333+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
Need to download KB3135244 to allow TLS 1.2 on SQL Server 2008 SP4.
Running SQL Server 2008 SP4 (10.0.6000.29). Can no longer connect via Zapier, which requires TLS 1.2. We plan to upgrade to SQL Server 2016 this year, but as a workaround to avoid data loss on mission critical systems, can we install KB3135244 to allow…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-24T21:16:36.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(19.2, 8%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mark Ely
0
Reputation points
answered 2026-03-25T05:58:25.8333333+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
how fix the error that occurs when I try to install SQL Server 2019
The following is the error message that I keep getting each time I tried to install SQL Server 2019: Unable to install SQL server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2025-12-02T13:56:13.8866667+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(44.800000000000004, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
CJAY Nwadinobi
5
Reputation points
commented 2026-03-24T12:18:40.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(240, 55.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
pukhrambam chandrakumar singh
0
Reputation points
1 answer
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2025-10-28T12:08:30.0033333+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(227.2, 17%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Donald Rutledge [EXT]
0
Reputation points
commented 2026-03-24T05:20:13.4866667+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
1 answer
Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated
Event error log :-fatal error occurred while reading the input stream from the network. The session will be terminated Impact:- Application is not working properly with below error. Error: TCP Provider, error: 0 - The specified network name is no…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2025-10-25T11:46:42.0033333+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(54.400000000000006, 10%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Jagadeesan E
0
Reputation points
commented 2026-03-24T05:11:53.7+00:00
Akhil Gajavelly
1,570
Reputation points Microsoft External Staff
Moderator
2 answers
ACE.OLEDB.12.0 provider is not registered on the local machine
Hello, We have a client that tried to import an excel using the import and export wizard and he recceived the following error: The operation could not be completed. Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-04T07:35:23.9466667+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(108.80000000000001, 63%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Admin Team TGS
0
Reputation points
recommended 2026-03-20T12:24:14.4266667+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(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
sql server 2022 wın 11 pro da kurulum sırasında sürekli aynı hata veriyor. ve kuramıyorum
kurumda yaşadığım probleminin sebebi nedir.? 2019, 2022, 2025 sqlserver kurulumlarıda aynı şekilde hata verdi.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-05T23:46:06.63+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(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Destek Bilgisayar
0
Reputation points
recommended 2026-03-20T12:24:00.44+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
sql server 2019 kurulum problemi
Hatalı kurulan SQL Server 2019 bileşenleri nasıl tamamen kaldırılır? temizleme işini otomatik yapacak bir uygulamanız yok mu ?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-03-05T20:51:37.03+00:00
Destek Bilgisayar
0
Reputation points
recommended 2026-03-20T12:23:47.96+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
CDC change Data Capture on High availibility AlwaysOn 2019
Hello, I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
676 questions
asked 2026-02-19T08:29:44.65+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(291.2, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mona Seddik
20
Reputation points
recommended 2026-03-20T12:21:54.7566667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator