20,130 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

SQL Server xp_copy_files security thoughts and able to specify files older than only?

Hello noticed somewhat of a new recent feature xp_copy_files (for SQL Server2019 & higher) which we have SQL Server 2022 (believe most things similarly were done previously via xp_cmdshell which had security concerns). Is it correct to say…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-08T22:37:16.5733333+00:00
techresearch7777777 1,921 Reputation points
0 answers

I have a issue with downloading SQL sever 2022

i dont know how to fix it, i try to unistall again multi times but nothing work, pls help me

SQL Server Database Engine
asked 2025-03-08T14:29:10.68+00:00
NGUYỄN ANH TUẤN 0 Reputation points
commented 2025-03-08T21:36:47.16+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

Does the Azure SQL Data Sync Agent require specific permissions on the On-Prem database?

I am setting up Azure SQL Data Sync - I have an Azure SQL SyncDB for the metadata and 2 member databases - one is Azure SQL and the other is an on-prem SQL DB (express). The agent is running correctly (test connection succeeded), and I am able to see my…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 questions
asked 2025-03-07T22:14:53.4733333+00:00
Power Admin 0 Reputation points
answered 2025-03-08T08:03:48.36+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

Potential Issues with Deploying to SQL Server 2016 Using sqlcmd from Linux in GitHub Pipeline

We are deploying to SQL Server 2016, where our developers use sqlcmd on Windows machines for development. However, our GitHub pipeline is using a Linux runner with sqlcmd on Linux for deployment. Could this setup cause any compatibility or operational…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-08T00:47:35.3733333+00:00
James, Ashwin (BC Pension) 0 Reputation points
answered 2025-03-08T07:59:55.44+00:00
Erland Sommarskog 118.9K Reputation points MVP
5 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 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.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 30 Reputation points
commented 2025-03-07T21:56:38.3233333+00:00
Yitzhak Khabinsky 26,461 Reputation points
5 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 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.
14,490 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 30 Reputation points
commented 2025-03-07T21:56:38.3233333+00:00
Yitzhak Khabinsky 26,461 Reputation points
1 answer

Can't enable change feed.

Hi All, My SQL SERVER is 2022 CU 16 and while try to enable change feed, Im getting this error I have run the query using sa EXECUTE sys.sp_change_feed_enable_db; error: Msg 22710, Level 16, State 1, Procedure…

SQL Server Database Engine
asked 2025-03-06T06:46:04.3666667+00:00
Vignesh K 20 Reputation points
edited the question 2025-03-07T21:34:51.62+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

Unable to install SQL Server(setup.exe)

I encountered this error during installation. I have tried several methods, including uninstalling SQL Server from 'Programs and Features' and deleting SQL Server entries in 'regedit', but I still face the same error when reinstalling. The detail.txt…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,009 questions
asked 2025-03-06T06:07:28.7+00:00
Thai Huy 0 Reputation points
commented 2025-03-07T20:13:24.59+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

Cannot start sql server service

Here is error log: Description: Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 15151, state 1, severity 16. This is a serious error condition which might interfere with regular operation…

SQL Server Database Engine
asked 2025-03-05T23:52:14.7966667+00:00
bestrongself 1 Reputation point
commented 2025-03-07T20:06:50.78+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

Select permission 2

Hello! Please excuse me for almost the same question as "Select permission" but there's one thing I'd like to be cleared up: I see that I can't query a user database (at least the databases for which the Guest account is disabled) until the…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-04T08:40:36.6933333+00:00
Hram Admin 80 Reputation points
commented 2025-03-07T19:29:11.78+00:00
Erland Sommarskog 118.9K Reputation points MVP
2 answers

How to grant upload to ssrs server

how to grant access to upload report rdl file to server

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,009 questions
asked 2025-03-06T17:56:51.9166667+00:00
Lawler, Bill 0 Reputation points
answered 2025-03-07T08:39:09.75+00:00
Olaf Helper 46,201 Reputation points
0 answers

summary.txt after rebuild the system database.

I ran the following command to rebuild the system database X:\Backups\2019>setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain\myusername Microsoft (R) SQL Server 2019 15.00.2000.05 Copyright (c) 2019 Microsoft. …

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-05T23:49:04.68+00:00
bestrongself 1 Reputation point
edited the question 2025-03-07T04:58:12.67+00:00
Pradeep M 6,325 Reputation points Microsoft External Staff
0 answers

sql server 2019 developer edition cumulative update The patch installer has failed to update the shared features.

sql server 2019 developer edition cumulative update The patch installer has failed to update the shared features. Overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason for…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-06T06:32:36.74+00:00
Mohan Kumar NATARAJAN 0 Reputation points
edited the question 2025-03-07T04:56:17.8966667+00:00
Pradeep M 6,325 Reputation points Microsoft External Staff
1 answer

Microsoft SQL Server 2022 Reporting Services not running on Windows 11 and Windows 10

I installed Latest SQL reporting services.exe from Microsoft webstite and when i try to run the exe of reporting sercies of sql22 . I am getting the following error and exe is not running to configure reporting service for SQL22 . Can someone know this…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,009 questions
asked 2025-03-06T13:51:26.81+00:00
Karan _447 0 Reputation points
answered 2025-03-07T02:35:28.58+00:00
ZoeHui-MSFT 41,286 Reputation points
2 answers One of the answers was accepted by the question author.

Restore is shutting the sql server down.

In the past when ever I restored the training system with backup of our production SIS I had to turn off the service and shut down the application pool or the restore would not be able to lock the DB's. Today I accidentally started the restore process…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,662 questions
asked 2025-03-05T23:48:45.47+00:00
John Steele 41 Reputation points
answered 2025-03-06T23:02:37.2033333+00:00
Erland Sommarskog 118.9K Reputation points MVP
1 answer

TLS 1.2 issues SQL 2022. What do these error messages mean.

I have SQL Server 2022 Developer edition running with enforced encryption (TLS 1.2). For some reason I have frequent disconnects, from the logs it states that TLS is successfully activated and also the certificates are loaded. More often I get the first…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-04T06:34:05.3366667+00:00
Freddy Vorstenbosch 0 Reputation points
edited the question 2025-03-06T21:59:42.8633333+00:00
Erland Sommarskog 118.9K Reputation points MVP
3 answers

SQL server 2022 reporting services installer setup file not run

I have try to run and install the SQL ServerReportingServices.exe file on the windows system. But the reportingservices installer file not run on the system. After that I have checked the event log of the system and found the below error message.…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,009 questions
asked 2024-09-06T03:13:33.8333333+00:00
Sanjeev Jalotia 0 Reputation points
answered 2025-03-06T19:20:05.77+00:00
leonorjohny 0 Reputation points
5 answers

Union two tabls with different columns

Hi Everyone, I have a table A that has 205 columns and table B that has 160 columns. Some of the columns in two tables matches but there are differnces. is there a simple way to do a union of two tables and get null for column that doesnt belong in…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,691 questions
asked 2022-03-03T07:17:49.363+00:00
Rohit Kochar 46 Reputation points
edited an answer 2025-03-06T15:03:59.9666667+00:00
Trond Erik Bones 0 Reputation points
2 answers

SQL Server T-SQL Debugging API

Hi, Where can I find the API to create a T-SQL debugger user interface? With regards, Martijn Tonies

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
147 questions
asked 2025-03-05T09:47:01.74+00:00
Martijn Tonies 0 Reputation points
answered 2025-03-06T01:34:45.1233333+00:00
LiHongMSFT-4306 30,996 Reputation points
3 answers One of the answers was accepted by the question author.

Tuncate log in log shipping SQL server to reduce size

Hi Support, We have 2 SQL servers running in log shipping and found the disk is out of space because the database log file too large, so we planned to truncate the DB log to reduce the size. First, any way to reduce the DB log size but not break…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2022-10-26T16:20:17.287+00:00
Chong 21 Reputation points
commented 2025-03-05T22:13:06.17+00:00
Erland Sommarskog 118.9K Reputation points MVP