20,369 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

SQL Server error code 4014 on Linux

Hi there! I'm getting an error 4014, severity 20, state 10 error in my SQL Server error log. It seems to happen at random intervals. This is for a SQL Server 2022 instance running on Red Hat Enterprise Linux 9.5. The client is making a connection using…

SQL Server Database Engine
asked 2025-04-29T16:04:17.6766667+00:00
Tim Coleman 0 Reputation points
1 answer

Failure sending mail: One or more errors occurred. Mail will not be resent. (SQL Server Reporting Services)

Have tried chatGPT ways as well could get a solution on the below result error: "Failure sending mail: One or more errors occurred" Check your SSRS log files (in \Program Files\Microsoft SQL Server\<Instance>\Reporting…

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,040 questions
asked 2025-04-29T11:02:58.1033333+00:00
Puneet Dasari 20 Reputation points
edited an answer 2025-04-29T15:22:36.3933333+00:00
Bruce (SqlWork.com) 74,956 Reputation points
1 answer

ASP.NET session has expired or could not be found (unable to find the solution) - SSRS Report

unable to find out the solution we have tried 2 things but there was no ouput: We have tried to extend the session time out to 30mins Tried to scale up the Azure speed when this error occurs Attached Screenshot for reference, kindly assist for the…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,598 questions
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,040 questions
asked 2024-12-18T14:24:39.5466667+00:00
Puneet Dasari 20 Reputation points
commented 2025-04-29T14:18:29.8566667+00:00
Puneet Dasari 20 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,371 Reputation points
1 answer

Issue to restore the schema

Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following     USE db_to_restore       go       ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE       go   but it…

SQL Server Database Engine
asked 2025-04-25T03:14:41.97+00:00
Peter_1985 2,731 Reputation points
edited a comment 2025-04-29T13:30:51.7766667+00:00
Dan Guzman 9,371 Reputation points
0 answers

SSIS - 13 or more different files from the same directory

Good morning, I'm trying to figure out a best SSIS solution for the following problem. I have 13 or more input files of different structure. I already designed 13 data flow tasks for these text files and I used string variables file1, file2, etc. for…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,678 questions
asked 2025-04-29T13:21:46.0233333+00:00
Naomi Nosonovsky 8,331 Reputation points
edited the question 2025-04-29T13:22:13.3666667+00:00
Naomi Nosonovsky 8,331 Reputation points
0 answers

I need to find a missing report

I'm searching for a report for one of our specialists on 04/07/25 who is no longer with TD as of this month. However the specialist name is no longer listed under the team manager for TD bank. I've left a comment but I have no idea who it goes to our…

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,040 questions
asked 2025-04-29T12:38:40.2833333+00:00
Gordon, Cliff (he/him/his) 0 Reputation points
1 answer

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,040 questions
asked 2025-03-06T13:51:26.81+00:00
Karan _447 0 Reputation points
commented 2025-04-29T12:29:24.8+00:00
Karan _447 0 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
1 answer

SQL Service Broker queue is not activated after the server reboot.

After the sql server reboot, service broker queues are not activated automatically. Even though the queues are on 'enabled' stage, we had to manually disable and enable the queues to start the processing immediately. Otherwise it takes around 3 to 4…

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,494 questions
asked 2020-11-28T22:50:00.277+00:00
NPT_NPT 6 Reputation points
edited a comment 2025-04-29T08:20:25.97+00:00
Milan Kolář 0 Reputation points
1 answer

How to index vector fields for semantic search in sql server azure

CREATE VECTOR INDEX idx_OpenAIEmbedding ON dbo.table_name (OpenAIEmbedding) WITH ( VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension SIMILARITY_FUNCTION = 'COSINE' ); Started executing query at Line 1 Msg 343, Level 15, State 2, Line…

SQL Server Database Engine
asked 2025-04-28T14:48:30.7966667+00:00
Jarle Holt 0 Reputation points
answered 2025-04-29T05:23:05.7666667+00:00
Olaf Helper 46,551 Reputation points
3 answers One of the answers was accepted by the question author.

Stored procedure not sending out emails using sp_send_dbmail

Greetings again mates, The following stored proc performs several different tasks at once. At the top of the SP, the SELECT statement queries two tables (Employees and AuthorizedUsers) to pull names and email addresses of employees based on some WHERE…

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,494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 questions
asked 2023-11-04T16:50:41.1533333+00:00
Simflex 301 Reputation points
accepted 2025-04-29T00:07:22.98+00:00
Simflex 301 Reputation points
1 answer One of the answers was accepted by the question author.

use the SAS tokens to read files stored in a container?

Hi, I'm trying to figure out how to use the SAS tokens to read files stored in a container. Could someone guide me on the correct way to use these tokens?

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,339 questions
asked 2025-04-28T18:05:40.49+00:00
sasthha 20 Reputation points
accepted 2025-04-28T20:54:16.34+00:00
sasthha 20 Reputation points
5 answers

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is…

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,494 questions
asked 2024-06-09T22:09:54.9333333+00:00
Eghost 0 Reputation points
commented 2025-04-28T18:38:47.18+00:00
Rojo 0 Reputation points
7 answers

How to install ms sql server on Windows 11 arm?

Hi all, I have a macbook so I installed Parallels and Windows 11 pro (arm). But I have a problem to install MS SQL Server on it. It seems to be imposible. Can you help me with this? Thanks a lot.

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,494 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
11,430 questions
asked 2023-10-30T08:29:45.66+00:00
Shirase 81 Reputation points
answered 2025-04-28T14:09:26.28+00:00
Lauren Glenn 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,678 questions
asked 2025-04-27T20:07:31.78+00:00
Naomi Nosonovsky 8,331 Reputation points
commented 2025-04-28T12:15:01.22+00:00
Naomi Nosonovsky 8,331 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 46,551 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.
563 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,040 questions
asked 2025-04-28T08:26:50.4333333+00:00
Swa1209 90 Reputation points