20,111 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

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.
139 questions
asked 2025-03-04T08:40:36.6933333+00:00
Hram Admin 80 Reputation points
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.
139 questions
asked 2025-02-26T05:37:46.5733333+00:00
T Lee 0 Reputation points
commented 2025-03-04T08:09:19.4233333+00:00
T Lee 0 Reputation points
2 answers One of the answers was accepted by the question author.

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.
139 questions
asked 2025-02-28T13:47:07.2233333+00:00
Hram Admin 80 Reputation points
commented 2025-03-04T07:25:32.6233333+00:00
Hram Admin 80 Reputation points
0 answers

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 Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
asked 2025-03-04T06:34:05.3366667+00:00
Freddy Vorstenbosch 0 Reputation points
2 answers

DBNETLIB error when trying to export my CRM database via SMSS. Need help troubleshooting, please

Alright so, all I want to do is export a CRM database. I've already tried allowing SMSS through the firewall, no dice. I've taken screenshots of my process and hyperlinked them to the steps below to clarify what I'm up to. I connect to CRM via SMSS. I…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,658 questions
asked 2025-03-03T21:09:27.54+00:00
blueHope202 0 Reputation points
answered 2025-03-04T06:02:52.6633333+00:00
ZoeHui-MSFT 41,206 Reputation points
2 answers

Performance counters

Hello , We are seeing the slow performance of the queries and wanted to know which performance counetsr we should focus on to get more info avout the the issues Thanks HImanshu

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.
139 questions
asked 2025-03-03T20:29:36.13+00:00
Himanshu Sinha 11 Reputation points
answered 2025-03-04T05:22:10.9866667+00:00
ZoeHui-MSFT 41,206 Reputation points
1 answer

SSRS - Displaying the page number in the body shows previous page number.

Hi, I have a report containing a tablix with a textbox (TextBox25) that needs to display the current page number. In the report code I have: Public Shared PageNumber as Integer Public Function ChangePageNumber(ByVal PageNum As Integer) PageNumber =…

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,006 questions
asked 2025-03-03T12:41:45.5866667+00:00
Michael Allen (SXS UK) 0 Reputation points
answered 2025-03-04T03:29:05.1633333+00:00
ZoeHui-MSFT 41,206 Reputation points
1 answer

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.
139 questions
asked 2025-03-04T00:15:41.4833333+00:00
Jason Price 0 Reputation points
answered 2025-03-04T02:37:53.08+00:00
LiHongMSFT-4306 30,916 Reputation points
2 answers

Performance between CTE vs Temp table

Hello , Just wanted to know if we have any performance benefits of using the CTE over temp tables ? Thanks Himanshu

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,006 questions
asked 2025-03-03T19:53:31.5866667+00:00
Himanshu Sinha 11 Reputation points
answered 2025-03-04T02:06:25.5233333+00:00
LiHongMSFT-4306 30,916 Reputation points
0 answers

while installing new sql instance getting error code: is not a valid installation folder

Hi Team we have an existing setup for sql server 2016 and package is available in c drive. Now we are creating new named instance at the time getting error "is not a valid installation folder" how to fix this issue. we tried copy the files to…

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.
139 questions
asked 2025-03-03T07:26:43.46+00:00
Ramakrishna M 0 Reputation points
commented 2025-03-04T01:45:25.4966667+00:00
LiHongMSFT-4306 30,916 Reputation points
2 answers One of the answers was accepted by the question author.

Should I use SSMS or 'Sentry Plan Explorer' in my scenario ?

Hello, I'm quite new in this area ... hence, apologize for the 'silly question'. I am using SSMS v18.12.1 My goal is to analyze slow performance in web-based application connected to MS SQL server. I tried to run 'slow' query in SSMS and then look into…

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.
139 questions
asked 2025-03-02T15:25:41.4833333+00:00
Voldman, Eliya 60 Reputation points
commented 2025-03-03T22:55:24.8633333+00:00
Erland Sommarskog 118.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

i cannot able to install SQL express edition, it is showing error.

i tried to install sql developer edition and express edition but both showing error, cannot able to install it. Please help me.

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,327 questions
asked 2025-03-03T20:44:24.13+00:00
Sindhu Nidadavolu 0 Reputation points
accepted 2025-03-03T22:52:40.9066667+00:00
Sindhu Nidadavolu 0 Reputation points
0 answers

Azure Data Sync Issue Records Does Not Update

Data records was not getting sync from Member to Hub

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.
139 questions
asked 2025-03-03T06:37:47.5433333+00:00
ZTS 20 Reputation points
commented 2025-03-03T16:25:50.6066667+00:00
Balmukund 81 Reputation points Microsoft Employee
2 answers

How can I change the thousand separator from comma(,) to point(.); from US to European format?

I want to change the way numbers are displayed from 1,411,344.95 to 1.411.344,95.

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,006 questions
asked 2022-01-20T12:51:49.573+00:00
Nimisha Vernekar 126 Reputation points
commented 2025-03-03T16:04:23.0166667+00:00
Ea 0 Reputation points
0 answers

SQL Server AOAG on multi subnet cluster using the same AD

Hi All, We have a SQL Server 3 node multi subnet cluster created having 2 node on production subnet and 1 disaster recovery (DR) node on another subnet but under the same domain/AD (One in Ohio and the other in NJ). What I know is that there should be…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
555 questions
asked 2025-03-03T14:51:53.7833333+00:00
Carlos D 51 Reputation points
edited the question 2025-03-03T14:58:13.69+00:00
Carlos D 51 Reputation points
0 answers

MAP - Microsoft Assesment tool does not pull correct (refreshed) data in sql server database details report

MAP - Microsoft Assesment tool does not pull correct (refreshed) data in SQL Server database details report. To check, I created a user XX on the SQL Server instance with the db_owner grant on the base and ran the report again. There is no user XX in…

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,327 questions
asked 2025-03-03T13:00:29.5333333+00:00
User91 0 Reputation points
edited the question 2025-03-03T13:03:45.3466667+00:00
simo-k 3,270 Reputation points
4 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,006 questions
asked 2025-02-28T10:56:40.1+00:00
Posmine Poulose k 0 Reputation points
answered 2025-03-03T07:45:50.96+00:00
Olaf Helper 46,201 Reputation points
2 answers

What are the different kinds of SSRS Reports?

I am new to SSRS and wanted to what are the different kinds of SSRS Reports?

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,006 questions
asked 2025-03-03T02:35:43.44+00:00
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
answered 2025-03-03T07:30:40.7366667+00:00
Olaf Helper 46,201 Reputation points
2 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.
139 questions
asked 2025-02-28T14:04:05.7333333+00:00
Madhusudhan M Kammar 0 Reputation points
answered 2025-03-03T06:10:04.3766667+00:00
ZoeHui-MSFT 41,206 Reputation points
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.
139 questions
asked 2025-02-28T09:32:57.27+00:00
Stefanos Evangelou 116 Reputation points
answered 2025-03-03T02:49:56.6166667+00:00
LiHongMSFT-4306 30,916 Reputation points