20,092 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

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.
132 questions
asked 28 Feb 2025, 9:32 am
Stefanos Evangelou 116 Reputation points
answered 28 Feb 2025, 10:39 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

Change collation of report services

I noticed that the default collation for the Report Server databases (ReportServer and ReportServerTempDB) in SQL Server Reporting Services is Latin1_General_100_CI_AS_KS_WS. However, my SQL Server instance collation is SQL_Latin1_General_CP1_CI_AS. I…

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,002 questions
asked 28 Feb 2025, 10:56 am
Posmine Poulose k 0 Reputation points
answered 28 Feb 2025, 10:29 pm
Erland Sommarskog 118K Reputation points MVP
1 answer

Select permissions

Hello! While creating reports using bcp utility - *bcp "select Name, physical_name, state_desc, (size)8/1024, ... from msdb.sys.database_files ORDER BY Name" queryout C:\REPORTS\SQ\LUSERDB.txt -c -T ... *bcp "select Name, physical_name,…

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.
132 questions
asked 28 Feb 2025, 1:47 pm
Hram Admin 60 Reputation points
answered 28 Feb 2025, 10:25 pm
Erland Sommarskog 118K Reputation points MVP
1 answer One of the answers was accepted by the question author.

SQL Server Issue

I cannot install any of the SQL Server versions. See a sample error I got from installing version 2014: TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: Unknown error (0xe0000235) For help, click:…

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,324 questions
asked 28 Feb 2025, 8:43 pm
Bola Elebiyo 0 Reputation points
accepted 28 Feb 2025, 10:21 pm
Bola Elebiyo 0 Reputation points
0 answers

Unable to open visual design tools in SSMS 20 or SSMS 21

Unable to open Visual Design tools in SSMS with 'sa' logon.

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,324 questions
asked 25 Feb 2025, 8:49 pm
MrBill 0 Reputation points
commented 28 Feb 2025, 10:12 pm
Erland Sommarskog 118K Reputation points MVP
0 answers

EXCEPTION_ACCESS_VIOLATION reading address 0000000000000006 at 0x00007FFB4711429B

I am getting the below exception while executing insert query on hash table Exception: spid 124 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 0000000000000006 at 0x00007FFB4711429B No values returned from the SQL Query. Please verify…

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.
132 questions
asked 28 Feb 2025, 2:04 pm
Madhusudhan M Kammar 0 Reputation points
commented 28 Feb 2025, 10:07 pm
Erland Sommarskog 118K Reputation points MVP
3 answers

How to Verify the Signed Status of a CLR Assembly with Asymmetric Key in SQL Server

CLR Strict Security is enabled - User databases have TRUSTWORTHY as OFF  In this scenario all CLRs are treated as unsafe and will not function, unless they are added to the trusted_assemblies or have an asymmetric key.  They have seen many issues with…

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 9 Jan 2025, 10:07 pm
Vanitha Dodla (MINDTREE LIMITED) 40 Reputation points Microsoft External Staff
commented 28 Feb 2025, 10:05 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

How to get in touch with someone regarding Azure SQL

I would love to speak to somone regarding: Microsoft Entra authentication  

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,656 questions
asked 28 Feb 2025, 4:00 pm
Antonioo Ferri 0 Reputation points
answered 28 Feb 2025, 10:03 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

removestaledbentries: cleanup of stale db entries skipped beacuse master db is not memory optimized

removestaledbentries: cleanup of stale db entries skipped beacuse master db is not memory optimized The above message is occurring frequently and persistently. How can I resolve this issue?" sql-server 2022

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.
132 questions
asked 26 Feb 2025, 5:37 am
T Lee 0 Reputation points
answered 28 Feb 2025, 8:55 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

Downlaod updated version of Microsoft OLE DB Driver for Microsoft SQL

Helo Team, Please let me know how to get the updated version for "Microsoft OLE DB Driver for Microsoft SQL" Below are other SQL applications installed

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,324 questions
asked 24 Feb 2025, 9:42 am
Boopathi S 3,671 Reputation points
commented 28 Feb 2025, 8:50 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

CPU HyperThreading Core evaluation

Hello, We are currently trying to evaluate our current On-Prem Sql Server CPU HyperThreading Core evaluation for license cost purpose. Our current Sql Servers are from 2014 to 2019 sql version. Is it any prefer way I can estimate that Sql server has 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.
132 questions
asked 27 Feb 2025, 8:32 pm
pdsqsql 411 Reputation points
commented 28 Feb 2025, 8:41 pm
Erland Sommarskog 118K Reputation points MVP
0 answers

listener issue

Failed to retrieve data for this request.(Microsoft.SQLServer.Management.sdk.sfc)

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.
132 questions
asked 27 Feb 2025, 5:10 am
Mohammad Abid (SONATA SOFTWARE NORTH AMERICA INC) 0 Reputation points Microsoft External Staff
commented 28 Feb 2025, 8:31 pm
Erland Sommarskog 118K Reputation points MVP
3 answers

a lot of SQL Server dump files generated almost on the same time in C disk whic

The version is Microsoft SQL Server 2017 - 14.0.3460.9. The issue happened on midnight, The application using SQL server didn't perform any Query ,Insert, Update ,Delete operation. We see a lot of error almost at the same time on Windows 10 event log.…

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,324 questions
asked 27 Feb 2025, 2:32 am
Xianjun Zhan 0 Reputation points
commented 28 Feb 2025, 8:27 pm
Erland Sommarskog 118K Reputation points MVP
2 answers

How to replace all illegal XML chars when casting to XML

Hi, What is the proper way to cast varchar value to XML which may contain illegal XML characters? Can you please explain with CDATA or should it be complex replace command? Thanks in advance.

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.
132 questions
asked 27 Feb 2025, 6:10 pm
Naomi Nosonovsky 8,191 Reputation points
answered 28 Feb 2025, 5:25 pm
Yitzhak Khabinsky 26,461 Reputation points
3 answers One of the answers was accepted by the question author.

SSRS 2022 does not show barcode when printing to PDF

We are using SSRS 2022. We have a report that has a barcode on it using BCC3OF9N.TTF. The barcode shows in preview mode when we run the report, but when it prints to PDF or exports to PDF the barcode does not show. I have verified the barcode is on the…

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,002 questions
asked 30 Dec 2024, 11:24 pm
DoveConnieDES-3786 26 Reputation points
answered 28 Feb 2025, 4:14 pm
Mr. Jack 0 Reputation points
1 answer

When trying to Restore SSAS Database get error The Request is not supported

Good Day, I am trying to restore a SSAS Database on SQL 2019, however keep getting the error: The following system error occurred: The request is not supported. (Microsoft.AnalysisServices.Core) I have tried running SSMS as admin and made sure my use…

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,324 questions
asked 27 Feb 2025, 11:33 am
Marius Smit 5 Reputation points
answered 28 Feb 2025, 4:07 pm
Marius Smit 5 Reputation points
1 answer One of the answers was accepted by the question author.

How to use the Get data features in Power Bi Desktop to import data from SQL Server

Hi, Could you please help me out? I'm stuck in this module. I have been trying to use the Get data features in Power BI to import data from SQL Server, but I keep getting an error message, unable to connect, and the message below.. Details:…

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.
13 questions
asked 27 Feb 2025, 7:52 pm
Naomi Anumudu 0 Reputation points
commented 28 Feb 2025, 12:38 pm
Syed Saleem Peera 11,680 Reputation points Microsoft External Staff
3 answers

how to solve this problem please tell me about this

how can solve this problem

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
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,885 questions
asked 14 Mar 2023, 7:16 am
Md.Thohedul Islam 0 Reputation points
commented 28 Feb 2025, 10:57 am
KRIPALSINH Sarvaiya 0 Reputation points
1 answer

Unable to access SQL over VPN

We have an on-premises Active Directory with Azure AD synchronization (ie: a hybrid environment). Our on-prem includes two separate AD forests that are connected with a two-way trust. For name sake, i'll call these: AD1.local and AD2.local. All client…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,656 questions
asked 27 Feb 2025, 12:04 pm
Philip Preece 41 Reputation points
answered 28 Feb 2025, 9:02 am
Philip Preece 41 Reputation points
0 answers

Unable to connect to DB due to full storage

due to replication slots filling the DB the storage gets full and crashes issue seems to be occurring every 2 weeks or so and can you help me to identify the reason why this occurs similar databases are set upped in the qa and the prod environment which…

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,324 questions
asked 27 Feb 2025, 12:35 pm
Soubhik Bhattacharya 0 Reputation points
commented 28 Feb 2025, 2:21 am
LiHongMSFT-4306 30,906 Reputation points