conditional join
hello, table1 has columns - col1,col2, col3 table2 has columns - col1,col2, col3 in my sql, I join the tables together by col1 but I also want to join via col2 and col3 only if col2 and col3 are present in table2 otherwise only join via col1. for…
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…
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…
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…
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 …
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…
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: …
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.
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. …
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…
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…
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
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…
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…
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…
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…
Benefits and disadvantages of WITH (NOLOCK)
Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.
"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.
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
Cannot alter column because it is 'ROWGUIDCOL'
After restoring a database one of my columns was changed from NULL to newid(). I tried to run ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'