Hi there I'm going to be a re your
Go to the refund payment related posts thumbnail of hi hi I am a
Unable to connect SQL server to Azure data factory
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-1J7NBOS', Database: 'DataWarehouse', User: 'ak2'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the…
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"…
I cannot install sql server on my windows 11. Keep getting an oops, exit decimal error code
I am unable to install sql server on my windows computer
SQL Server 2019 download
I currently have SQL Server 2016 but got a db backup from a 2019 server and found that it isn't backwards compatible. I just want to be able to download a copy of SQL Server 2019 that's not an eval copy and would prefer to get it from Microsoft. Can…
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…
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…
ssis package upgrade fail
I am trying to upgrade my SSIS packages from sql 2016 to 2019. The steps I did is opened the project in Visual Studio 2022, and then set the targetversion to 2019. And then Upgrade all the packages. It completed without any errors. But when I open one of…
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.
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…
Service Broker Queue - Receive
Hi, I want to read SQL service broker messages and push to Azure service bus. And my .net core application is used for the same. Currently I am using 'receive' command. The problem with 'receive' is that the message is getting deleted from service broker…
Trying to Bulk Insert SSN data into an always Encrypted column and is not working. Any guidance please.
I am having trouble Bulk inserting the SSN data from a simple SQL table to a table where I have an always encrypted column. I am not getting any right solution after googling around. Please share if anyone has done similar kind of work. Thanks, SK.
“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQL Server 2014 is almost complete
“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQ L Server 2014 is almost complete
Why does impersonation (Execute as) work in a User database and not in the master database in Azure SQL DB?
Execute As User = 'User1' doesn't work in the Azure SQL DB master database. User1 account created in the master database and in a user database. Execute As User works in the user database and in the master database, receives the error: Msg 15517, Level…
SSMS not flagging basic errors after IIF statement
DMF_SSMS_SQL_IIF_Err.pdf I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then…
how to fix Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an
Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an…
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…
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 :…
SQL 2016 Linked Server Problems
I am trying to setup a linked server connection to another DB running a non-MSSQL DB. On the local server the account I am using has Sysadmin right on the remote server the local DB account has what they call Admin rights as well. We have tried using…
could not load file or assembly'Microsoft.data.sqlclient'
how to solve this error