20,127 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
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 Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 questions
asked Mar 5, 2025, 11:52 PM
bestrongself 1 Reputation point
commented Mar 6, 2025, 11:32 PM
bestrongself 1 Reputation point
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,661 questions
asked Mar 5, 2025, 11:48 PM
John Steele 21 Reputation points
answered Mar 6, 2025, 11:02 PM
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 Mar 6, 2025, 6:07 AM
Thai Huy 0 Reputation points
answered Mar 6, 2025, 10:50 PM
Erland Sommarskog 118.9K Reputation points MVP
0 answers

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 Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,328 questions
asked Mar 6, 2025, 6:46 AM
Vignesh K 20 Reputation points
commented Mar 6, 2025, 10:49 PM
Erland Sommarskog 118.9K Reputation points MVP
0 answers

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 Mar 6, 2025, 1:51 PM
Karan _447 0 Reputation points
edited the question Mar 6, 2025, 10:31 PM
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.
144 questions
asked Mar 4, 2025, 8:40 AM
Hram Admin 80 Reputation points
commented Mar 6, 2025, 10:10 PM
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.
144 questions
asked Mar 4, 2025, 6:34 AM
Freddy Vorstenbosch 0 Reputation points
edited the question Mar 6, 2025, 9:59 PM
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 Sep 6, 2024, 3:13 AM
Sanjeev Jalotia 0 Reputation points
answered Mar 6, 2025, 7:20 PM
leonorjohny 0 Reputation points
0 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 Mar 6, 2025, 5:56 PM
Lawler, Bill 0 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 Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 questions
asked Mar 5, 2025, 11:49 PM
bestrongself 1 Reputation point
edited the question Mar 6, 2025, 3:06 PM
Sreekanth Nadendla 491 Reputation points Microsoft Employee
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 Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 questions
asked Mar 6, 2025, 6:32 AM
Mohan Kumar NATARAJAN 0 Reputation points
edited the question Mar 6, 2025, 3:05 PM
Sreekanth Nadendla 491 Reputation points Microsoft Employee
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,692 questions
asked Mar 3, 2022, 7:17 AM
Rohit Kochar 46 Reputation points
edited an answer Mar 6, 2025, 3:03 PM
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.
144 questions
asked Mar 5, 2025, 9:47 AM
Martijn Tonies 0 Reputation points
answered Mar 6, 2025, 1:34 AM
LiHongMSFT-4306 30,916 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 Oct 26, 2022, 4:20 PM
Chong 21 Reputation points
commented Mar 5, 2025, 10:13 PM
Erland Sommarskog 118.9K Reputation points MVP
2 answers

How to truncate logs with log shipping enabled

Hello, I have a SQL Server 2016 server with multiple SQL Server instances acting as primary server in a log shipping configuration. I have configured log shipping as per…

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.
144 questions
asked Feb 28, 2025, 9:32 AM
Stefanos Evangelou 116 Reputation points
commented Mar 5, 2025, 10:11 PM
Erland Sommarskog 118.9K Reputation points MVP
3 answers

Purpose to use timestamp datatype in sql server?

Hello, What is the purpose to use timestamp datatype in sql server? Do you have a concrete example of using timestamp in real business case? When is it relevant to use timestampe datatype? Thank you!

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 Jan 20, 2021, 10:12 PM
JJ TT 141 Reputation points
commented Mar 5, 2025, 9:52 PM
Erland Sommarskog 118.9K Reputation points MVP
2 answers

Download Writers for SQL 2017

In my environment I am running backups on my SQL 2017. The backup is failing due to SQL VSS writers. The service is present but still doesn't work when running and after restarting. I went to look at vssadmin list writers in elevated command prompt, SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,661 questions
asked Mar 4, 2025, 2:29 PM
shana bright 0 Reputation points
commented Mar 5, 2025, 8:31 PM
shana bright 0 Reputation points
1 answer One of the answers was accepted by the question author.

Git Automation with SQL Tools and Visual Studio Code

So here's my situation: We have a database application created and maintained by a third party We have access to the application to debug/extend that application to meet our needs The third party software developer regularly modifies the application…

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.
144 questions
asked Mar 4, 2025, 12:15 AM
Jason Price 20 Reputation points
edited a comment Mar 5, 2025, 6:45 PM
Bruce (SqlWork.com) 71,871 Reputation points
2 answers

Reporting Services exception logged when calling Extensions rest api

Whenever a user calls the "Reports/api/v2.0/Extensions" GET method of reporting services Rest API, the following error is logged in the ReportingServicesService log file: library!ReportServer_0-1!472c!03/28/2023-09:32:14:: e ERROR: Throwing…

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 Mar 28, 2023, 2:46 AM
Michael He 0 Reputation points
answered Mar 5, 2025, 3:53 PM
Benjamin Titze 1 Reputation point
5 answers One of the answers was accepted by the question author.

SSIS Script Task - Edit Script not working

This is a common recurring issue on Microsoft SSIS Projects development IDE on Visual Studio Community 2019 (Windows 10): given a Script Task the edit button that should open a Visual Studio Intance (VSTA) to work on C# code do not react to the click.…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,661 questions
asked Sep 30, 2022, 12:21 PM
Paolo Cos 31 Reputation points
commented Mar 5, 2025, 3:09 PM
Román Pérez Contreras 0 Reputation points