1,100 questions with SQL Server-related tags

Sort by: Updated
0 answers

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,066 questions
asked 2025-04-30T21:12:59.78+00:00
Ryan Brothers 0 Reputation points
0 answers

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
0 answers

Failed to update the SQL server 2019 CU27+GDR with KB5040948

Dear All, Currently I'm facing and issues of applying SQL server 2019 CU as below: Summary the Step:  1. Unable to open the file installer of KB5040948, as below: The below are the error logs in Setup Bootstrap log: Overall summary: Final result: The…

SQL Server Database Engine
asked 2025-04-30T08:49:13.38+00:00
Ung Seyha 21 Reputation points
0 answers

Upgrading SQL Server from 2016 to 2022 SSIS query

Hi, I am looking to upgrade around 6 virtual machines utilizing SQL Server 2016 to 2022. One of these servers runs multiple SSIS jobs hourly and I am concerned that the upgrade will cause incompatibility for these jobs. I have been informed that these…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-04-30T07:37:41.6266667+00:00
Jon Burrows 0 Reputation points
0 answers

sp_executesql is not working when sql server is running in a container

sp_executesql is not working when sql server is running in a container. The issue only happens when I specify collation as Latin1_General_BIN docker command: docker run -d -p 1433:1433 -e 'ACCEPT_EULA=Y' -e "MSSQL_SA_PASSWORD=$db_password" -e…

SQL Server Database Engine
asked 2025-04-28T04:24:18.5333333+00:00
Yeturu Jagadeesh Reddy 0 Reputation points
commented 2025-04-29T14:04:11.3933333+00:00
Dan Guzman 9,406 Reputation points
0 answers

SQL Database writes suddenly slow.

Writing to SQL Server Database has suddenly become very slow since April 26th 2025. Everything is run on premise within the same region. Nothing has changed on our end. Writing tasks that once took 11 seconds now take 3 minutes. Writing tasks that once…

SQL Server Database Engine
asked 2025-04-29T11:53:57.68+00:00
R 0 Reputation points
0 answers

Added package from disk to a project then tried to rename it, but the original name is preserved in the project

Good day, I added a package saved on disk to an SSIS project. I then modified it and renamed. However, the original name with (1) is still shown in the project although I can see that the newly named package is saved in the project directory. But the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-04-27T20:07:31.78+00:00
Naomi Nosonovsky 8,431 Reputation points
commented 2025-04-28T12:15:01.22+00:00
Naomi Nosonovsky 8,431 Reputation points
0 answers

How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.

How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.

SQL Server Database Engine
asked 2025-04-26T14:13:18.2733333+00:00
sathish kumar 0 Reputation points
commented 2025-04-28T11:03:33.25+00:00
Olaf Helper 47,516 Reputation points
0 answers

udpStagingSweep Stored Procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019.

Hi I am upgrading Master Data Services from 2012 to 2019, It appears that the udpStagingSweep stored procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019. Over the major version…

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.
569 questions
asked 2025-04-28T09:35:40.0566667+00:00
Shah, Syed 0 Reputation points
edited the question 2025-04-28T10:14:14.32+00:00
Shah, Syed 0 Reputation points
0 answers

SQL DB not Found

Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…

SQL Server Database Engine
asked 2025-04-28T08:46:47.8233333+00:00
Shabir jan 21 Reputation points
0 answers

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,066 questions
asked 2025-04-28T08:26:50.4333333+00:00
Swa1209 90 Reputation points
0 answers

Error during setup process of SQL 2022 express

Detailed results: Feature: Database Engine Services Status: Failed Reason for failure: An error occurred during the setup process of the feature. Next Step: Use the…

SQL Server Database Engine
asked 2025-04-28T02:58:13.41+00:00
Nick Parker 0 Reputation points
commented 2025-04-28T06:38:12.73+00:00
Nick Parker 0 Reputation points
0 answers

The specified service does not exist as an installed service- SQL Server 2022

Hi I am trying to install SQL server 2022 and getting the error pop up: "The specified service does not exist as an installed service". Any solutions please let me know. I have also attached the screenshot of error and Detail.txt file from log…

SQL Server Database Engine
asked 2025-04-25T09:44:10.43+00:00
sudheer 5 Reputation points
edited the question 2025-04-25T09:53:26.97+00:00
sudheer 5 Reputation points
0 answers

How to migrate large tables of size around 30gb from sql server 2014 to sql server 2022?

Hi , what would be the best way to migrate table of size 30 GB from sql server 2014 to sql server 2022?

SQL Server Database Engine
asked 2025-04-22T18:29:14.89+00:00
Kumari, Dimpy 0 Reputation points
commented 2025-04-24T14:36:17.25+00:00
Kumari, Dimpy 0 Reputation points
0 answers

WSFC Issues with Node failing Over but the Roles stay on the old primary

Hi Hope someone can help me out here, last couple of nights our WSFC has failed over, The servers have not been restarted but the Primary Node failed over to the Secondary node, though none of the Availability Groups moved with the failover, all the…

SQL Server Database Engine
asked 2025-04-24T08:30:40.1133333+00:00
Clive Wightman 146 Reputation points
0 answers

Unable to Silent install SQLServerReportingServices.exe version 2022 Version: 16.0.1117.32

Unable to silent install SQLServerReportingServices.exe**.** It runs for a few seconds and then exits. No log. No folder created in C:\program files. Double clicking this exe will launch the GUI installer and installs without issue. Downloaded…

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,066 questions
asked 2025-04-23T20:53:26.99+00:00
Ryan Naylor 0 Reputation points
0 answers

How to recover the Azure sql flexible server database from the deleted resource

My resource is accidently deleted need to get the backup of the mysql database from the deleted resources how should i get it .

SQL Server Database Engine
asked 2025-04-23T19:29:54.5066667+00:00
Lavanya Yatin 20 Reputation points
0 answers

Auto Pause Setting up an ElasticJob Server on serverless

I have set up my main database server on Microsoft SQL Azure (Cloud). This is up and running. I need to run jobs at scheduled times. I believe I need to set an Elastic Job Agent. I go through the steps to "Create Elastic Job Agent" Under…

SQL Server Database Engine
asked 2025-04-23T08:50:51.93+00:00
Chris Twinn 0 Reputation points
0 answers

Azure SQL to Fabric

I'm thinking to move to Fabric from the below set up. Have the following questions. We currently use ADF to extract data from netsuite via selfhosted VM (odbc) + Provisioned Azure SQL for data processing data into facts and dimensions (3 independent fact…

SQL Server Database Engine
asked 2025-04-22T20:58:19.35+00:00
RJ 326 Reputation points
0 answers

Azure SQL Slowness

I use ADF to extract data sources + Provisioned Azure SQL for data processing data into facts and dimensions (3 independent fact tables + 10 dimensions). DB size is around 550GB. Total GB allocated 950. I have a prod and dev version (same db name). NONE…

SQL Server Database Engine
asked 2025-04-22T20:37:18.23+00:00
RJ 326 Reputation points