SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,950 questions
4 answers
How do you install SQL Server 2019 using Microsoft Intune
I converted the SQL exe tool to intunewin format, but there are many additional files needed to fully set up the application in silent mode that i do not know how to include in the intune win32 application package option. Also, i wanted to use a batch…
asked 2021-04-22T14:22:59.293+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(16, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAU%3C/text%3E%3C/svg%3E)
acarr urbanscience
1
Reputation point
edited an answer 2024-05-31T05:43:45.81+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(243.2, 11%, 33%)' 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)
Sukhbaj Singh
0
Reputation points
3 answers
Help required with SQL Server
Hi Team, Could you please reply to below 2 points - I have a requirement where I need to identify all windows machines where Microsoft SQL Server is installed (any version). To identify I have gone to control panel of each machine(inside uninstall and…
asked 2024-05-30T10:08:43.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(275.2, 61%, 36%)' 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)
Salil Singh
20
Reputation points
answered 2024-05-31T03:45:06.0033333+00:00
MikeyQiao-MSFT
825
Reputation points Microsoft Vendor
3 answers
how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…
asked 2024-05-02T02:52:39.4733333+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(25.6, 15%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Ted Yin
0
Reputation points
commented 2024-05-31T03:15:37.14+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
SQL Licensing for SQL Always ON Availability group
Hello Guys, I need to understand how many licenses i need to buy for SQL always on availability group, below is my requirement. As per my understanding only active cores should be licensed SQL always on cluster Primary site: Server 1 : Active copy …
asked 2024-05-02T06:33:28.6+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, 85%, 16%)' 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)
mohammed arifuddin
25
Reputation points
commented 2024-05-31T03:15:06.89+00:00
LucyChenMSFT-4874
1,815
Reputation points
1 answer
Do ODBC Linked Servers (MariaDB) support XA Transactions?
My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server with…
asked 2024-05-03T20:31:26.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(249.60000000000002, 49%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Evan Howlett
0
Reputation points
commented 2024-05-31T03:14:28.0966667+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
Error description: The system cannot find the path specified while installing SQL server management studio
I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …
asked 2024-05-06T16:23:40.68+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(41.6, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nikita Gaur
0
Reputation points
commented 2024-05-31T03:14:03.2366667+00:00
LucyChenMSFT-4874
1,815
Reputation points
3 answers
How to sql dump generation on sql server 2008 ?
Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.
asked 2024-05-13T16:40:04.5466667+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(16, 49%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tidiane TRAORE
0
Reputation points
commented 2024-05-31T03:12:10.9933333+00:00
LucyChenMSFT-4874
1,815
Reputation points
4 answers
How to restore SQL server 2019 database backup (.bak) to SQL server 2017.
Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …
asked 2024-05-14T05:26:36.97+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, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shyam Kumar
0
Reputation points
commented 2024-05-31T03:11:30.03+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
Custom skill integration Azure AI Search
0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…
asked 2024-05-15T18:18:35.6533333+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, 2%, 35%)' 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)
Somdeep Niyogi (external)
1
Reputation point
commented 2024-05-31T03:10:10.61+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
One of the answers was accepted by the question author.
How can I sync data from a source database table without primary key to the destination database table with primary key
Hi all, If the source MS SQL SERVER 2017 database table does not have primary key but destination MS SQL SERVER 2019 database table has primary key, what is the best way or method to make both tables data in sync? Please take into consideration that…
![](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(76.8, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
4 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
asked 2024-05-16T12:03:46.98+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-31T03:07:04.0466667+00:00
LucyChenMSFT-4874
1,815
Reputation points
3 answers
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V
40
Reputation points
commented 2024-05-31T03:05:40.31+00:00
LucyChenMSFT-4874
1,815
Reputation points
1 answer
Troubleshooting SQL Server Replication Error During Version Upgrade
How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10…
asked 2024-05-22T03:50:56.0266667+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, 35%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vanitha Dodla (MINDTREE LIMITED)
40
Reputation points Microsoft Vendor
commented 2024-05-31T03:04:48.8+00:00
LucyChenMSFT-4874
1,815
Reputation points
3 answers
Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block
Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…
asked 2024-05-23T13:55:55.1133333+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(3.2, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Viacheslav Nikonorov
0
Reputation points
commented 2024-05-31T03:03:13.9066667+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
sql server agent alert failed
hello I have this problem with my SQL Server Agent, the service is working properly but when I make alert by some program running by SQL Server it shows that SQL Server agent is not working even if it is working, where should the problem be?
asked 2024-05-29T07:47:16.79+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(156.8, 34%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed Al Mohalami
0
Reputation points
commented 2024-05-31T03:01:13.3133333+00:00
LucyChenMSFT-4874
1,815
Reputation points
1 answer
How to change the logo for SQL Server Master Data Services (MDS) in 2019
This used to be accomplished in the SQL Server Master Data Services (MDS) 2016 version by changing the logo.png file.
asked 2024-05-29T13:40:17.81+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, 5%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Novicki, Joseph
0
Reputation points
commented 2024-05-31T03:00:49.05+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
can you guys help me, I always get this error when importing management studio sql files.
The given value '24,269' of type String from the data source cannot be converted to type int for Column 7 [rating_count]. (Microsoft.Data.SqlClient) Failed to convert parameter value from a String to a Int32. (Microsoft.Data.SqlClient) Input string was…
asked 2024-05-30T08:14:13.89+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(70.4, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
muhammad fajar
0
Reputation points
answered 2024-05-31T02:18:39.5233333+00:00
ZoeHui-MSFT
33,946
Reputation points
5 answers
Upgrade required
Hi Team, I am having SQL Server 2022 Developer edition on my windows machine. I need to upgrade below (to avoid any security vulnerability) - SQL Server 2022 Developer edition OLEDB ODBC Please let me know the steps(links) for same. Let me know if…
asked 2024-05-29T18:03:08.4666667+00:00
Salil Singh
20
Reputation points
edited a comment 2024-05-31T01:17:41.03+00:00
LucyChenMSFT-4874
1,815
Reputation points
2 answers
One of the answers was accepted by the question author.
Benefits and disadvantages of WITH (NOLOCK)
Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.
asked 2024-05-30T15:12:46.18+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(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
100
Reputation points
answered 2024-05-30T21:20:01.3066667+00:00
Erland Sommarskog
102.6K
Reputation points
1 answer
One of the answers was accepted by the question author.
"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
asked 2024-05-29T08:24:57.7533333+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(252.8, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Erick Rae Q. Nobleza
20
Reputation points
commented 2024-05-30T19:51:30.58+00:00
Alberto Morillo
33,161
Reputation points MVP