21,836 questions with SQL Server-related tags

Sort by: Updated
1 answer

Is SQL Server 2025 Standard Developer Edition Licensed for Automated Restore Testing?

Hello everyone, We are planning to set up a dedicated SQL Server instance exclusively for automated backup restore testing. Our production SQL Server databases are backed up regularly. Using dbatools, these production backups will be automatically…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-10-22T06:41:11.02+00:00
Augustin, Christopher 0 Reputation points
answered 2026-10-22T12:56:03.7333333+00:00
Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to measure the server execution time of SQL

I want to know how long it takes for the server to complete the SQL after it is sent to the server, so that I can determine whether the time consumed when the program executes it is mainly in SQL Server, the network, or the backend/frontend program.

SQL Server | SQL Server Transact-SQL
asked 2026-10-21T10:31:37.69+00:00
博雄 胡 785 Reputation points
accepted 2026-10-22T01:20:53.7366667+00:00
博雄 胡 785 Reputation points
2 answers

Get-AzDataMigrationAssessment Generates Inconsistent JSON Formats and an Additional HTML File.

Hello Microsoft Team, I am using the Get-AzDataMigrationAssessment PowerShell cmdlet from the Az.DataMigration module to generate SQL Server migration assessment reports. The assessment covers the following three scenarios: …

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-10-15T13:29:15.21+00:00
Shivam Singh 0 Reputation points
answered 2026-10-21T17:55:02.7966667+00:00
Deepesh Dhake 1,325 Reputation points
2 answers One of the answers was accepted by the question author.

numMsgsRcvd:1 should be less than numMsgsSent:1

I was starting up my Program as the following error occured: E/AndroidRuntime: FATAL EXCEPTION: pool-2-thread-1 Process: de.heffnersoftware.hsproduction, PID: 8295 java.lang.AssertionError: numMsgsRcvd:1 should be less than numMsgsSent:1 at…

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,717 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2021-06-08T16:10:00.403+00:00
Alexander 21 Reputation points
commented 2026-10-21T15:51:33.3066667+00:00
David Engel 0 Reputation points Microsoft Employee
3 answers

Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer

Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-02-22T20:30:09.4333333+00:00
Sabyasachi Paul 0 Reputation points
commented 2026-10-20T13:37:39.8866667+00:00
Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator
1 answer

SSRS Permissions Issue: User Unable to View Reports despite Browser Role

Hello, I’m facing an issue with SQL Server Reporting Services (SSRS). I have a user who is assigned to the “Browser” role on the folder, but despite this, the user is unable to view the reports. The user receives the error: Does anyone have…

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,188 questions
asked 2025-04-28T08:26:50.4333333+00:00
Swa1209 90 Reputation points
answered 2026-10-20T04:45:01.19+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

PDF Export with a custom font giving the error "Cannont find or create the font 'xyz,Bold'."

I've ran into an issue I have never seen before, maybe somebody could help before I pull my hair out any more. We've got some reports we did for a customer in SSRS. They work fine and render fine. Recently the customer gave us a custom font their…

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,188 questions
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers 0 Reputation points
answered 2026-10-20T04:42:54.9066667+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?

Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…

SQL Server Database Engine
asked 2025-04-30T10:31:00.4933333+00:00
Yasir Anis Janjua 0 Reputation points
answered 2026-10-20T04:41:17.67+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

Report server doesn't support schedule refresh when using SharePoint Online as the data souce

Hi team, According to this page, https://learn.microsoft.com/en-us/power-bi/report-server/data-sources. I noticed the power BI report server doesn't support schedule refresh when connecting to SharePoint Online related as the data source. Would there be…

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,188 questions
asked 2026-09-17T01:36:22.14+00:00
Yang Zhao 0 Reputation points
answered 2026-10-20T04:39:34.0433333+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

Help with the Azure SQL DTU Calculator

I am trying to load a CSV file into the DTU Calculator without success. Refer https://dtucalc.azurewebsites.net/ I receive a generic error message: Error! An error occurred while processing your request. See below for the first few lines of the CSV file…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-09-17T23:24:19.2066667+00:00
Alan Macdonald 0 Reputation points
answered 2026-10-20T04:38:11.76+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

Need original microsoft hecksum value for latest Microsoft Command Line Utilities for SQL Server before downloading

Hi, I need to download the latest version of Microsoft Command Line Utilities x64 for SQL Server for Windows OS. I can see it is available here: https://learn.microsoft.com/en-us/sql/tools/bcp/bcp-download-install?view=sql-server-ver17 Before installing…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-09-22T12:47:14.6166667+00:00
GVC 10 Reputation points
answered 2026-10-20T04:36:41.02+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

Cube failure due to data length issue

Cube failure with below error “Errors in the OLAP storage engine: An error occurred while the 'Diagnosis' attribute of the 'DimUniqueDiagnosis' dimension from the 'CQMC_RBGBGWS_Analysis_Test' database was being processed.” We are doing SL3 to SL4 server…

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,380 questions
asked 2026-09-24T10:17:43.5566667+00:00
Kayal 0 Reputation points
answered 2026-10-20T04:34:57.0766667+00:00
Rukshan edirisinghe 2,125 Reputation points
1 answer

Problemas persistentes al instalar y desinstalar SQL Server: error en KERNELBASE.dll y bloqueo de sqlservr.exe

Estoy experimentando problemas persistentes al intentar instalar y ejecutar SQL Server en mi PC. El problema continúa incluso después de desinstalar y reinstalar SQL Server y eliminar las carpetas de instalación. Según el análisis realizado por el…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-10-19T20:58:44.25+00:00
Mauro Mariño 0 Reputation points
commented 2026-10-19T21:18:14.9633333+00:00
Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator
1 answer

electronic signature report

Is there a report I can pull electronic signatures by provider in Expanse?

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,188 questions
asked 2026-10-19T18:44:03.38+00:00
Block Alyssa 0 Reputation points
answered 2026-10-19T18:46:01.86+00:00

AI answer

2 answers

Request to speak to a representative about SQL express

I cannot install sql express. Can I speak to a representative?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2026-10-19T14:09:13.83+00:00
miriam litwin 0 Reputation points
edited an answer 2026-10-19T17:04:23.55+00:00
Bruce (SqlWork.com) 85,621 Reputation points
7 answers One of the answers was accepted by the question author.

Where are the SQL Server developer edition downloads

Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?

SQL Server Database Engine
asked 2026-03-24T22:21:49.96+00:00
Steve Margolis 35 Reputation points
answered 2026-10-19T15:24:38.8833333+00:00
Reich, Christian 0 Reputation points
2 answers

Non-User Account Information

Currently can export the report for one owner only. We need requirement to pull this report for Level6 Org. ?Can we have this feature?

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,188 questions
asked 2026-10-19T13:24:31.3566667+00:00
Nitin Jain 0 Reputation points
answered 2026-10-19T14:21:52.2133333+00:00
Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator
1 answer

How to avoid refreshing full data everytime on refreshing in on premises PowerBI Dashboards

I work in a finance corporate where there is a lot of data in our on premises PowerBI dashboards from either sql or excel, so on regular basis we face challenges on refreshing all the dashboards as every time it refreshes from the beginning, so I want a…

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,380 questions
asked 2026-10-19T11:28:50.89+00:00
Syed Uzair 0 Reputation points
answered 2026-10-19T11:30:58.0933333+00:00

AI answer

1 answer One of the answers was accepted by the question author.

How to Replace %S with Feature Value on Feature String Based on Feature Name and partid?

I work on sql server 2017 i need write select query Replace %S with Feature Value on Column Feature String Based On partid and Feature Name Related . as example partid 1211 have Feature String AC(%S)Boil(%S)Temp(%S) I need to replace %S…

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,717 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,827 questions
asked 2022-06-09T17:50:14.997+00:00
ahmed salah 3,216 Reputation points
commented 2026-10-17T23:15:32.8+00:00
jenari millender 0 Reputation points
1 answer One of the answers was accepted by the question author.

New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)

SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…

SQL Server Database Engine
asked 2026-08-21T14:07:13.2433333+00:00
Hubert 20 Reputation points
commented 2026-10-17T20:34:38.23+00:00
Erland Sommarskog 138.4K Reputation points MVP Volunteer Moderator