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
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
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
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
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
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
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
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
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 | Other
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
Cannot see RD amount
I am not seeing the RD amount on the SQL Services Reporting screen
SQL Server Reporting Services
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
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
No Param Pane is SSRS
I do not have a parameters pane in design view using ssrs report builder. Help.
SQL Server Reporting Services
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
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
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
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
How to install SQL Server when it says network error even though my network is strong ?
SQL Server | Other
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