SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
2 answers
SQL Bulk Copy failed
SQL Bulk Copy failed due to receive an invalid column length from the bcp client. I am getting this error while copying data from adls to sqlserver. I am copying a csv file. I checked the length of each and every column. Destination has more length when…
asked 2022-09-26T05:37:18.833+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(22.400000000000002, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
KEERTHANA JAYADEVAN
66
Reputation points
answered 2024-07-05T17:22:54.8266667+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,721
Reputation points
1 answer
SQL Server Backup in Azure VMs
The Azure backup for SQL VM doesn't allow the selection of multiple databases to be restored through the Azure portal. E.g. if I need to restore 10 databases which have already been backup up by Azure backup, I need to go through the restore process 10…
asked 2024-07-05T16:58:17.4633333+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(38.4, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
Onetrowon Emmanuel
0
Reputation points
answered 2024-07-05T17:21:44.39+00:00
Vahid Ghafarpour
20,480
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server connection timeout after idle
I just set up on Azure a SQL Server (free tier) connecting to an .NET Core web app also on Azure. After 20 minutes the database goes idle. The first attempted connection to the database fails with the call stack below. The subsequent call works…
asked 2024-07-04T17:35:16.3733333+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(233.6, 41%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Patricia Davidson
0
Reputation points
commented 2024-07-05T16:37:31.1233333+00:00
Patricia Davidson
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Installing MSSQL on Surface Laptop 7 with Snapdragon
I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,998 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,791 questions
asked 2024-07-03T15:08:36.85+00:00
CandidKilsborne
20
Reputation points
commented 2024-07-05T16:11:26.88+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
60,361
Reputation points
1 answer
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
asked 2024-06-24T15:08:42.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(297.6, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
20
Reputation points
commented 2024-07-05T15:27:27.5966667+00:00
Aleksey Vitsko
20
Reputation points
1 answer
I am trying to access SQL Server hosted in Azure VM from Azure function app
I am trying to access SQL Server hosted in Azure VM from Azure function app, but getting connection timeout error while connecting through it.
asked 2024-07-04T13:03:53.9366667+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, 18%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ritika Pandey
25
Reputation points
commented 2024-07-05T14:50:19.19+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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Duserla
645
Reputation points Microsoft Vendor
0 answers
SSPI Error when connecting from Intune Managed AVD to SQL Host using SSMS
Hi All, I have a problem when trying to connect to a SQL Server using SSMS via an Entra joined and Intune Managed AVD. The SQL host is in an AD DS where accounts are synced to Entra AD. The error I get is : The target principal name is incorrect. …
![](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(230.39999999999998, 52%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
1 answer
No "Run Now" button in SSRS Subscriptions
Hi, I have SSRS v13.0.5026.0 but do not have a "Run Now" button that I can use when I select a subscription in the list of subscriptions or in the individual report subscription page. There is only New Subscription, Enable, Disable and…
asked 2024-07-05T09:58:48.4366667+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(144, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tony Wright
0
Reputation points
answered 2024-07-05T10:29:39.8066667+00:00
Olaf Helper
42,761
Reputation points
3 answers
When i try to connect MSSQLSERVER server it doesn't appear and only the SQLEXPRESS server appears.
I've installed SQL2022-SSEI-Dev then installed the SQL2022-SSEI-Expr then the SSMS-Setup-ENU when i open the SSMS to connect a server i cant find DEV server and only the Express server appears. What's wrong and how to fix?
asked 2024-07-05T01:05:50.22+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(313.6, 61%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
ABDELHALEEM MOHAMMED
0
Reputation points
answered 2024-07-05T09:15:48.32+00:00
Erland Sommarskog
105.8K
Reputation points MVP
0 answers
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…
asked 2024-07-05T06:27:34.9366667+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(272, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tú Nguyễn
65
Reputation points
commented 2024-07-05T09:13:08.1166667+00:00
Erland Sommarskog
105.8K
Reputation points MVP
2 answers
Unable to install SQL Server Exit Code (Decimal): -2068052294. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor
I just bought this laptop to support my study for data analysis (Dell XPS 13 which run on Window 11). When I tried to both install SQL Express 2019 or 2022, I cannot install the application and the same error occurred as mentioned above. I have tried…
asked 2024-07-04T17:00:33.37+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(57.599999999999994, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Minh Phuc Le
0
Reputation points
commented 2024-07-05T08:58:57.84+00:00
Erland Sommarskog
105.8K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
side effects of giving permissions to run traces
Hi All, I would like to know the downsides of giving permissions to run traces in lower environments (DEV/QA/UAT). Our DB team has only two members: one supports PST hours, and the other supports IST hours. The PST resource is on leave for a month, so I…
![](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, 13%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
Automatic startup of SQL server when configured with SCCM.
I have configured SCCM with a remote SQL server in the same domain, and it is working fine. When I stop the SQL server in the remote machine, it gets started automatically in a few minutes. I want to know who is responsible for automatically starting…
asked 2024-07-01T13:52:21.2366667+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(172.8, 3%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sathis Babu
0
Reputation points
commented 2024-07-05T05:58:21.63+00:00
AllenLiu-MSFT
42,356
Reputation points Microsoft Vendor
4 answers
DataSource.Error: Microsoft SQL - Power BI
Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process.…
asked 2024-07-04T14:38:30.8166667+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(172.8, 82%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Gaston N Escobar
0
Reputation points
answered 2024-07-05T05:18:53.1833333+00:00
Olaf Helper
42,761
Reputation points
4 answers
Index Rebuild
I read somewhere that in index rebuild, sql server first creates new index and then drops old on. Is it correct? OR it drops the old index and then creates new index?
asked 2024-07-01T15:15:18.72+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
776
Reputation points
edited a comment 2024-07-05T03:13:17.6033333+00:00
MikeyQiaoMSFT-0444
1,585
Reputation points
1 answer
sql server install not properly
TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…
asked 2024-07-04T04:46:59.23+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(9.6, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Ashutosh Olekar
0
Reputation points
commented 2024-07-05T02:35:55.69+00:00
MikeyQiaoMSFT-0444
1,585
Reputation points
1 answer
SQL SERVER 2022 The system cannot find the specified path
I had previously downloaded SQL SERVER 2022 to my personal computer, but I got an error so I wanted to delete it and install it again. I'm getting a lot of errors when reinstalling, thank God I solved them all but now I can't solve this error, can you…
asked 2024-07-04T07:29:39.15+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(246.4, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
MERT CAN ÖZBAY
0
Reputation points
edited an answer 2024-07-05T01:57:59.5+00:00
LucyChenMSFT-4874
2,825
Reputation points
1 answer
ISNULL - Clarification on how Nullable on data type affects for resultant columns
Data Creation: Create Table: create table tone_12 ( col_1 varchar(20) NULL, col_2 varchar(40) NULL, col_3 varchar(20) NOT NULL, col_4 varchar(40) NOT NULL, col_5 as isnull(col_1,col_4), col_6 as isnull(col_2,col_3) ) Insert statement: Insert into tone_12…
asked 2024-07-04T16:13:24.5433333+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(83.2, 89%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashwin Kanumoori
40
Reputation points
answered 2024-07-04T20:20:43.8133333+00:00
Erland Sommarskog
105.8K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
SQL Server 2022 Import and Export Wizard & Microsoft.ACE.OLEDB.12.0
Hello All Please advise on what needs to be done to fix this error << The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine >> All feedback welcome Thanks Steve Microsoft SQL Server 2022 (RTM-CU13) (KB5036432) -…
asked 2024-07-04T11:21:48.9433333+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(230.39999999999998, 35%, 32%)' 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)
Stephen Keogh
20
Reputation points
accepted 2024-07-04T15:50:20.36+00:00
Stephen Keogh
20
Reputation points
3 answers
Training database PUBS
Dear friends, I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please? Thank you very much, Anna
asked 2021-05-07T16:47:27.23+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(265.6, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
BIVS Databaze
1
Reputation point
answered 2024-07-04T12:13:44.9366667+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(172.8, 72%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Anthony Lesar
0
Reputation points