I have a code segment to send XML data through SQL Server DB Mail, which is working fine. The problem is, that I have to give names of columns manually in XML part of code. I need a way to pick …

Jul 4, 2018 · Solution what I know is to replace all single quotes with 2 single quotes but i want a dynamic query to replace single quoted with 2 single quotes in this string.

Jul 24, 2018 · Clusterless Always On Availability group can be configured in SQL 2017 with cluster type set to None. Is this supported configuration for SQL server running on Windows environment or is it …

Oct 26, 2018 · Question 1 : If you could have a look at the configuration mentioned in the below article, you can find SSL certificate for transfering the data to Azure SQL Database by checking the …

Oct 15, 2018 · It seems you have created external data sources on your Azure SQL Database. You need to remove them (NT4DbSrc), export the database as bacpac then try to import the database …

In addition, you may know that Semantic modeling language (SMDL) report models are deprecated in SQL Server Reporting Services 2012 and later versions. Customers can continue to use existing …

Data Warehouse failed to request a list of management packs which contain reports deployed to SQL Reporting Services Server. Fehler beim Anfordern der Verwaltungspaketliste von SQL RS Server …

Apr 24, 2018 · We are planning to upgrade as follow. Please correct me if i am wrong. 1) We are planning to create new node SQL 2016 (2 node) with Failover cluster. 2) Set up the storage with …

Jun 7, 2018 · The nt_username column is populated with my windows account. However, when running Extended Events the nt_username is blank. As SQL Server has access to my windows account …

Jun 15, 2018 · 1) Change the service account of SQL Server to be a domain account or a GMSA (Group Managed Service Account) and grant permissions to this account. 2) Add DOMAIN\MACHINNAME$ …