20,523 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

Execution of the stored procedure gives different result comparing with the direct execution

Hi everybody, I'm getting very puzzling results executing stored procedure vs executing subset of the code from that stored procedure directly. I have the following code to execute SP: DECLARE @RC INT DECLARE @inp_region_nbr TINYINT = 1 DECLARE @inp_npi…

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.
196 questions
asked 2025-06-13T22:28:35.3266667+00:00
Naomi Nosonovsky 8,431 Reputation points
commented 2025-06-14T02:43:39.66+00:00
Viorel 122.1K Reputation points
0 answers

Can't create a SQL Database server in East US region.

Hello Team, We would like to create a SQL Database server in East US region. But we see the following error - "Your subscription does not have access to create a server in the selected region. For the latest information about region…

SQL Server Database Engine
asked 2025-06-13T22:13:23.32+00:00
Rohit Khansili 0 Reputation points
edited the question 2025-06-13T22:14:00.1766667+00:00
Rohit Khansili 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to give a user SQL permission to execute stored procedure using powershell invoke-sqlcmd

Hi All, Hope someone has a solution for me. I have a MS SQL 2016 server. I have created a stored procedure and set execute as to Owner. I would like to have standard user be able to run this stored procedure using the PowerShell command invoke-sqlcmd.…

SQL Server Database Engine
asked 2025-06-05T22:39:26.3333333+00:00
Craig Garland 336 Reputation points
commented 2025-06-13T21:46:13.39+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
1 answer

SQL Server Enterprise Edition (Server + CAL) + Software Assurance – Licensing Compliance with More Than 20 Cores

I would like to confirm if my current SQL Server configuration is compliant with Microsoft licensing rules. Here are the key points: ·       We have a Microsoft SQL Server Enterprise Edition license. ·       Our company has always Software Assurance. ·  …

SQL Server Database Engine
asked 2025-06-13T12:31:45.9466667+00:00
Jaroslaw Pelc 0 Reputation points
answered 2025-06-13T20:14:38.0133333+00:00
Bruce (SqlWork.com) 77,321 Reputation points Volunteer Moderator
3 answers

Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?

Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…

SQL Server Database Engine
asked 2025-06-12T12:44:51.11+00:00
Sebastien Flaesch 26 Reputation points
commented 2025-06-13T16:55:32.9+00:00
Davide 1 Reputation point Microsoft Employee
0 answers

SQL Server Always On – Intermittent Cluster Failures in Test Setup

I am reaching out to receive support for SQL Server Always On configurations, specifically involving multi-node clusters with geographically distributed replicas in a test environment. I am currently evaluating the integration of an asynchronous…

SQL Server Database Engine
asked 2025-06-13T14:17:10.49+00:00
Matthew Tanner 0 Reputation points
0 answers

Integrating PHP Web App with SSRS

Hi. I’m new to the SSRS Reporting Service. I’m on Windows Server 2022 and SQL Server 2019.. I have configured the Report Server Configuration Manager and in Web Service URL tab it shows an URL [http://SEVRERNAME/ReportServer]. When I hit the URL it asks…

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,054 questions
asked 2025-06-13T08:55:11.1966667+00:00
Vijay Raghavan 0 Reputation points
0 answers

SSRS decommission

Can someone provide information on the decommissioning timeline for SSRS (SQL Server Reporting Services) and any planned sunset dates? Additionally, what support does Microsoft offer for migrating SSRS reports, and are there any recommended approaches or…

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,054 questions
asked 2025-06-12T18:26:05.3066667+00:00
GitaGhule-0977 0 Reputation points
commented 2025-06-13T05:15:03.3133333+00:00
GitaGhule-0977 0 Reputation points
0 answers

SSRS-generated Word .doc files don't render correctly in MS Word 2505

SSRS 2022 version 16.0.9276.19198 generates Word 97-2003 .doc files which can be opened fine in MS Word 2504. Word 2505 doesn't display the same .doc files correctly. Is there a version of SSRS that generates Word .docx version 2007…

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,054 questions
asked 2025-06-12T20:58:49.1+00:00
Zoltan Takacs 0 Reputation points
2 answers

SQL Server 2022 : Issue Restoring Database from 2014 Fails Without 'sysadmin' Role

We are attempting to restore a SQL Server 2014 database to SQL Server 2022. The process includes updating the database compatibility level from 120 (SQL 2014) to 160 (SQL 2022) after restoration. The issue we are encountering is: The restore and…

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.
567 questions
asked 2025-06-12T06:28:17.4766667+00:00
Pagare, Ankit 0 Reputation points
answered 2025-06-12T17:32:40.31+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
1 answer

Configure Resource Governor for SQL Jobs with SQL Login

How can a CheckDB job be configured to use Resource Governor to assign work to the checkDBworkpool for a SQL Login (specifically mylogin)? The challenge arises from the inability to create a proxy for SQL Logins when setting up the SQL job step, which…

SQL Server Database Engine
asked 2025-06-11T12:42:49.72+00:00
Sai Praneeth Eranti 210 Reputation points
edited a comment 2025-06-12T16:58:50.35+00:00
Sai Praneeth Eranti 210 Reputation points
3 answers

Unable to acquire authorization token (ConnectionDlg.AadInteractiveAuthProvider) with "Azure Active Directoy - Universal with MFA" to Azure SQL server when SSMS is run as my privileged account

This works fine from another system, or if I log on to the laptop directly with my privileged account. I need to run SSMS as my privileged account, because that's the only account that has been authorized to connect to our Azure SQL servers &…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
9,093 questions
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,492 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
24,957 questions
asked 2024-10-07T14:33:49.44+00:00
Dom-Su BoChum 20 Reputation points
commented 2025-06-12T15:57:35.9866667+00:00
Adrian De La Haye 0 Reputation points
0 answers

Unable to install sql server 2022 in Windows 11

Unable to install SQL server 2022 screen got stuck so please help me. I have attached screenshot for your reference.

SQL Server Database Engine
asked 2025-06-12T06:19:59.57+00:00
Ramchandra Bhuse 0 Reputation points
commented 2025-06-12T15:40:08.52+00:00
Balmukund 176 Reputation points Microsoft Employee
2 answers

How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website.

Hi, How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website. Please Help

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,492 questions
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,492 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,054 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,054 questions
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,343 questions
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,343 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
asked 2022-03-17T05:24:08.337+00:00
Faizan Ahmed 1 Reputation point
commented 2025-06-12T11:57:38.4266667+00:00
Ilya 0 Reputation points
2 answers

How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website.

Hi, How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website. Please Help

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,492 questions
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,492 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,054 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,054 questions
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,343 questions
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,343 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
asked 2022-03-17T05:24:08.337+00:00
Faizan Ahmed 1 Reputation point
commented 2025-06-12T11:57:38.4266667+00:00
Ilya 0 Reputation points
9 answers One of the answers was accepted by the question author.

Can you recommend a sql formatter?

Dear colleagues, Which SQL formatter would you recommend? In our organization, we have coding standards. My problem is, there are to many of them. As I am responsible for the repositories containing SQL, I want to enforce a single standard by…

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,492 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
asked 2020-11-17T14:17:45.18+00:00
Chris Sijtsma 106 Reputation points
answered 2025-06-12T08:53:11.8266667+00:00
Don Price 0 Reputation points
1 answer

Performance issue while reorganizing an index on a very large table

Hello Team, We're encountering a performance issue while reorganizing an index on a very large table (1.4TB with 1.5 billion records) in one of managed instance in other tenant. Since index reorganization is an online activity less impact our user…

SQL Server Database Engine
asked 2025-06-10T14:10:34.1266667+00:00
Joby Mathew 5 Reputation points
answered 2025-06-12T03:21:22.8833333+00:00
Phoa Poniman 0 Reputation points
1 answer

Error installing SQL Express

I am trying to install SQL server Express 2022. I have tried a few times including using https://www.sql-easy.com/learn/how-to-uninstall-sql-server/ and https://vladdba.com/2025/01/22/repair-a-sql-server-instance/ to uninstall and repair the install. I…

SQL Server Database Engine
asked 2025-06-11T16:39:00.3966667+00:00
JB 0 Reputation points
answered 2025-06-11T21:33:29.53+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
0 answers

Javascript in URL does not create a link in SSRS 2022

In SSRS 2022, using the below Javascript will not generate a link once deployed. This feature works fine in SSRS 2016 and before. Browser version does not…

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,054 questions
asked 2025-06-11T18:58:06.9833333+00:00
Patrick Dill 0 Reputation points
edited the question 2025-06-11T18:58:43.9566667+00:00
Patrick Dill 0 Reputation points
1 answer

JavaScript not working with ssrs report in edge

I working with an ssrs document and have images with a go to url that I inserted a JavaScript javascrpt:void(window.open http:\ the command completed works on a url command line within edge but if I click on the item nothing happens with the ssrs…

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,054 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,062 questions
asked 2024-08-20T03:26:06.5466667+00:00
Mark Tash 25 Reputation points
commented 2025-06-11T17:36:33.04+00:00
Patrick Dill 0 Reputation points