How to "restore" AdventureWorks .bak into Azure SQL Database
I'm trying to get the AdventureWorks dataset into a new Azure SQL Server Database, using the instructions here : https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms When I connect to the…
![](https://techprofile.blob.core.windows.net/images/dvtSEeSdTEKYuGmKbAh5Eg.png?8D8858)
Command sp_create_sbs_file in pool SQL - Azure Synapse
Hi, We discovered last week that pool SQL from Synapse ran the query “sp_create_sbs_file” multiple times and the usual queries were not being run. I would like to know why this command executes and what actions we can take to work around the problem. I…
Why are the database rows are getting deleted automatically sql
I got a copie from a comany to to make a projet and i createt a table in the database and some times wenn i log in on the pc all the rows from the table are delete it happent to me 3 times now last time was Friday an now monday and it is not a trigger…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
OLE DB Driver for SQL Server not working for external db host
Hello, I am having the same issue with our Connection Manager (see link below - new device with VS2019 installed plus SQL Server Integration Services Projects / SQL Data Tools). The recommendation is to change the 'Provider' from SQL Server Native Client…
After migrating to Windows 11 - Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied)
I just moved to a Windows 11 PC and now when using SSMS and I try to do a Bulk Insert into a SQL 2017 database, I get this error. Cannot bulk load because the file could not be opened. Operating system error code 5 (Aaccess is denied) I can do the same…
SSIS Wizard new mapping file not found
Hi I am attempting to migrate a Sybase ASA database to SQL Server using the 'SQL Import and Export Wizard' within Visual Studio 2019. I am able to run the wizard and create a package but the datatype mappings are not correct, e.g. datetime is mapped…
To load appfile format files into SQL Server In this process we need to change file format or we can directly import the appfile format files to view the actual appfile format data. what is the extension of appfile to upload this files on SQL Server .
Hi Team To load appfile format files into SQL Server In this process we need to change file format or we can directly import the appfile format files to view the actual appfile format data. what is the extension of appfile to upload this files on SQL…
Convert of HTML
Hello How to convert the html data in a table column to table format and store in another table Thanks
Facing issues to connect with synapse workspace/azure sql db via oauth
I want to connect to and access my Synapse Workspace and SQL Pool using OAuth. For this purpose, I have created an app in Azure and assigned the following API permissions: Microsoft Graph: Directory.Read.All (Delegated) Directory.ReadWrite.All…
secondary replica disconnected when joined in Availability Replica
If someone experience error message below: how is it fixed? 2023-02-15 07:11:03.100 spid31s A connection time-out has occurred on a previously established connection to availability replica 'SQLPRIMARY' with id [<replicaid>]. Either a networking or…
Built in SQL server in synapse is unavailable
Hi, Even after changing the firewall settings, the built in SQL server status is unavailable. Someone please assist. Step-by-step solution would be really helpful. Thanks in advance.
![](https://techprofile.blob.core.windows.net/images/lvNaBJBqh0eurOu4q2bQSQ.png?8DA4E8)
Multiple Users Read/Write to same SQL record
Hello, I have a pretty simple database that is read and written to through an asp.net c# website. Users see a grid with data and they can open a record to make changes. More than one user can open that same record, and what I am finding out is that when…
![](https://techprofile.blob.core.windows.net/images/SClx3RWTrEKkXmthAyq7Tw.png?8DC805)
SQL Statement taking long to execute
I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Replication in-place upgrade is failing from 200R2 to 2016
Hi All, We are doing upgrade from SQL 2008R2 to SQL 2016, during upgrade replication feature is failing. Its asking to check SQL Logs, we checked SQL logs and there is no errors. Let me know how to proceed on this. Error: Feature: …
Connection between on-premises SQL server with Azure data factory
I tried to connect my local SQL server to Azure data factory but getting this error. Credentials are ok I double checked it Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'localhost', Database: 'XXXXXXXXXX',…
SQL Server is terminating because of fatal exception c0000005
Facing this SQL Server access violation error on SQL Server 2016 (13.0.6435.1) running on Azure VM during startup! Error: 17311, Severity: 16, State: 1. SQL Server is terminating because of fatal exception c0000005. This error may be caused by an…
Visual Studio 2022 unable to connect to excel
Hi Folks, I wish to connect to Excel sheet from my Visual studio 2022 however when I create a connection and ran it the following error was produced. I am running Win10 64bit. ERROR Exception from HRESULT: 0xC020801C Error at Package [Connection manager…
I am making a connection to mssql using typeorm and getting error
Hi, I am trying to create connection to my mssql server using typeorm in node 20 application. I am getting socket hang-up error, the connection gets created if I set encrypt to false. I tried all tls configuration and everything but I am not able to…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
What component of I/O subsystem caused database corruption in my SQL Server
As per Error 824 that has occurred in my SQL error Log, I have found that the I/O subsystem is the cause of the database corruption. Error 824 However, I want to dig further and understand which specific component of the I/O subsystem caused the…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)