20,917 questions with SQL Server-related tags

Sort by: Updated
0 answers

how to modify index maintenance script

Hi Team, How to modify T-sql indexmaintenance script only do Index Reorganize

SQL Server | SQL Server Transact-SQL
asked 2025-10-14T23:33:02.8266667+00:00
Vijay Kumar 2,061 Reputation points
2 answers One of the answers was accepted by the question author.

SQL EXECUTION TIMEOUT ERROR on SSMS v21

Hello, When queries that take longer than 30 minutes are executed, the following error pops up: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding'. I am currently using SSMS…

SQL Server Database Engine
asked 2025-10-14T08:43:42.99+00:00
Manish Bundhun 0 Reputation points
answered 2025-10-14T20:43:10.8433333+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator
1 answer

Linked Server shows local databases rather than Linked Server databases

we cannot get any Linked Server to work using WIA. the Linked Server show the local databases. if we use SQL accounts it works. we don't want to use SQL accounts.

SQL Server Database Engine
asked 2025-10-09T13:24:24.3166667+00:00
Carl94580345 41 Reputation points
commented 2025-10-14T20:38:28.34+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator
2 answers

SSMS V22 times out on large queries where v19 did no

Hello, I use my laptop with SQL Developer to prototype databases before publishing them on a live SQL server. My laptop crashed and I had to reinstall all of the software. In my old laptop I was using SQL Server v2016 (not sure about this version) and…

SQL Server | SQL Server Transact-SQL
asked 2025-09-26T19:18:21.06+00:00
Claudio Cavalli 5 Reputation points
commented 2025-10-14T20:26:05.6166667+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator
0 answers

KB5065426 Security update - SQL Server Failover cluster (AlwaysOn) problems

Hi. Has anyone else experienced problems after the september KB installation on Windows Server 2025 ? We are running SQL Server 2022 in a Always-On scenario with Failover cluster on two nodes. After the installation, we are unable to connect to the…

SQL Server Database Engine
asked 2025-09-15T06:45:23.0233333+00:00
24551988 20 Reputation points
commented 2025-10-14T17:50:36.95+00:00
Adnan Rana 0 Reputation points
2 answers

SQL server AG stability issue on Linux Ubuntu - 3 Node cluster

SQL server AG stability issue on Linux Ubuntu - 3 Node cluster Issue: I have a 3 Node AG using pacemaker in Linux on Ubuntu When I do a automatic failover test by shutting down primary node , the Listener fails over to another node without any issue.…

SQL Server Database Engine
asked 2025-10-10T02:17:53.04+00:00
Raaghav Raaghav 0 Reputation points
commented 2025-10-14T13:29:06.9933333+00:00
Raaghav Raaghav 0 Reputation points
1 answer

How to resolve this error "Wait on the Database Engine recovery handle failed" while installing SQL server 2019 exp

Screenshot 2025-09-30 184033.png

SQL Server Database Engine
asked 2025-09-30T13:44:55.02+00:00
naveen kumar 0 Reputation points
commented 2025-10-14T12:10:17.13+00:00
Shruti Dhruv 10 Reputation points Microsoft External Staff Moderator
2 answers

How to create PDF in SSRS without clicking the EXport button

I wrote a lot of standard SSRS reports, by using VS 2019, and deploying to an SSRS report server. When I design, I'm not connected to the report server. I would like to write an SSRS Report that can produce a formatted report, and writes that to a PDF…

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,093 questions
asked 2023-06-15T17:58:25.2433333+00:00
Coreysan 1,816 Reputation points
commented 2025-10-14T11:53:27.4133333+00:00
Avinash Pottipadu 0 Reputation points
3 answers One of the answers was accepted by the question author.

SSRS Going Away?

I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…

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,093 questions
SQL Server | Other
asked 2024-04-19T19:31:42.4666667+00:00
Colin Sachs 40 Reputation points
commented 2025-10-14T11:50:16.1466667+00:00
Avinash Pottipadu 0 Reputation points
1 answer

Unable to access purchased Volume Licensing licenses

我们之前通过个人 Microsoft 帐户在 Volume Licensing Service Center (VLSC) 上注册和管理 SQL Server 许可证。由于 VLSC 现在已被停用,并且所有批量许可管理都已 consolid 到 Microsoft 365 管理中心,我的个人 Microsoft 帐户再也无法访问企业/学校许可信息,当我尝试在 Services Hub 中创建批量许可支持请求时,也无法继续进行到第 2 步。 当前情况: 在安装SQL Server…

SQL Server | Other
asked 2025-09-20T10:46:31.3566667+00:00
靖 陈 0 Reputation points
answered 2025-10-14T11:12:09.58+00:00
Prashanth Are 0 Reputation points Microsoft External Staff Moderator
0 answers

Cannot see RD amount

I am not seeing the RD amount on the SQL Services Reporting screen

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,093 questions
asked 2025-09-20T09:36:59.2266667+00:00
John Rose 0 Reputation points
commented 2025-10-14T10:11:04.08+00:00
Venkata Ramanamma Uppu (Quadrant Technologies LLC) 0 Reputation points Microsoft External Staff
1 answer

Getting HttpException, Unable to validate data

I'm setting up brand new SSRS 2022 Reporting Services with custom (Forms) authentication. I followed instruction from here,…

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,093 questions
asked 2025-09-08T18:20:38.8033333+00:00
Scott 0 Reputation points
answered 2025-10-14T09:53:04.6633333+00:00
CHIPPA ANJAN KUMAR 0 Reputation points
1 answer

When downloading a report what does data feed open with?

I have a sql server and there is a report that I normally download into CSV. I noticed an option for data feed and was wondering what that opens with and what it does.

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,093 questions
asked 2025-09-23T17:50:16.7466667+00:00
Manus, Jennifer 0 Reputation points
answered 2025-10-14T07:39:30.77+00:00
Karpurapu Durga Prasanna (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff
1 answer

No Param Pane is SSRS

I do not have a parameters pane in design view using ssrs report builder. Help.

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,093 questions
asked 2025-09-11T01:42:08.1366667+00:00
Manzi, John 0 Reputation points
answered 2025-10-14T07:33:04.2566667+00:00
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator
1 answer

Does PBIRS support data extension?

Custom data processing extensions (custom data sources) are not supported in Power BI Report Server. The only extension types still supported are: Authentication extensions (custom security providers) **Delivery extensions** (custom delivery…

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,093 questions
asked 2025-09-02T08:23:42.5966667+00:00
Sara Li 0 Reputation points
edited an answer 2025-10-14T07:13:14.93+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
1 answer

xa_recover buffer corruption with gtrid/bqual != 64 [ODBC Driver 18 for SQL Server]

I have noticed whenever I have a XID with gtrid and/or bqual length != 64, that xa_recover only returns sizeBuffer = 140 (1 XID) even though i have prepared 2 XA Transactions. If I have gtrid/bqual length both 64 I get sizeBuffer = 280 (2 XIDs) and can…

SQL Server Database Engine
asked 2025-10-09T09:26:45.0266667+00:00
AdventureT 20 Reputation points
edited a comment 2025-10-14T05:50:26.8066667+00:00
AdventureT 20 Reputation points
3 answers

Why are my SQL Servers not running and won't run when I try to start them? How do I fix this?

I am trying to download new time clock software for my business, TimePilot Central 5. I keep getting error stating cannot connect to SQL Server. I have updated Windows 11, shut off my firewall, unistalled TimePilot and restarted my computer and then…

SQL Server Database Engine
asked 2025-10-01T19:45:49.73+00:00
Amber Cheramy 0 Reputation points
commented 2025-10-14T00:16:52.88+00:00
Amber Cheramy 0 Reputation points
0 answers

What collations does sys.fn_get_audit_file_v2 support

When calling the function on a server with default collation Latin1_General_100_CI_AS_SC_UTF8 I get this error: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS_SC_UTF8" in…

SQL Server Database Engine
asked 2025-09-03T08:56:40.3666667+00:00
Jakob Hommelhoff 0 Reputation points
commented 2025-10-13T21:56:06.3866667+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator
asked 2025-10-13T16:42:14.9966667+00:00
LÊ ANH DŨNG 0 Reputation points
answered 2025-10-13T20:49:54.2033333+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator
1 answer

Sort columns in data table

How to sort order of rows in a pyspark dataframe in Fabric in ascending order based on the column of price?

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,355 questions
asked 2025-10-13T16:46:44.71+00:00
Abhinava Maddha 0 Reputation points Microsoft Employee
answered 2025-10-13T20:47:05.2166667+00:00
Erland Sommarskog 127.1K Reputation points MVP Volunteer Moderator