20,970 questions with SQL Server-related tags

Sort by: Updated
2 answers

SQL Server patching and information on Cumulative Updates and Security Updates(GDR and CU GDR)

Hello Support, I am a bit confused of what the patches mean and contain for SQL Server and will appreciate if you can clarify this for me: My question is for SQL Server 2019( but it is also applicable for SQL Server 2022 We have the RTM version…

SQL Server Database Engine
asked 2025-10-24T08:54:05.6366667+00:00
iliyan Rashev 0 Reputation points
commented 2025-10-28T15:38:55.2866667+00:00
iliyan Rashev 0 Reputation points
0 answers

Temp Table and Temp DB Space issues

We are recently having issues with Temporary Tables and Temp space failing on some of our jobs. We have asked our DBA if increasing Temporary space and Temp DB is an option and apparently it is not as Temp Space is already allocated fairly high. Just…

SQL Server | SQL Server Transact-SQL
asked 2025-10-28T14:45:59.14+00:00
Bobby P 231 Reputation points
0 answers

How to install/add Powershell 2.0 to Windows update 25H2?

How can I add PowerShell 2.0 to a Windows 11 Version 25H2 update?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,743 questions
asked 2025-10-28T13:53:14.2766667+00:00
Roger Whitsett 0 Reputation points
1 answer

creating subscription for SCOM Audit Reports throws error

On the SSRS for SCOM ACS the Audit Reports, running SQL 2022 CU20 When I try to create a subscription I get the error “Subscription can't be created or edited because the credentials used to run the report are not stored, or if a linked report, the link…

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,101 questions
asked 2025-10-24T19:50:15.99+00:00
Carl94580345 41 Reputation points
commented 2025-10-28T13:50:52.5333333+00:00
Carl94580345 41 Reputation points
1 answer

Como superar el error de instalación de sql server ID 2061893606

Hola a todos/as, agradezco me puedan ayudar a resolver este inconveniente, tengo Windows 11 y ya he intentado varias instalaciones con sus respectivas limpiezas en regedit y unidad C, adjunto el detalle del logDetail.txt

SQL Server Database Engine
asked 2025-10-27T19:36:14.6833333+00:00
DAVID VILLAMIL 0 Reputation points
commented 2025-10-28T13:30:26.87+00:00
DAVID VILLAMIL 0 Reputation points
4 answers One of the answers was accepted by the question author.

Microsoft SQL Management Studio for Mac

Hi, Is there any Mac version for Microsoft SQL Management Studio? Where can I get it from? Thanks, Jassim

SQL Server | Other
asked 2023-04-27T10:10:32.4133333+00:00
Anonymous
commented 2025-10-28T12:51:49.8666667+00:00
Gerardo Buenrostro 6 Reputation points
1 answer One of the answers was accepted by the question author.

How to solve the occasional timeout issue?

I aim to identify the cause and address the issue where the SQL execution time of occasional program calls exceeds the program's timeout threshold within a certain period, such as one day, after a timeout occurs. May I ask how I should proceed? I have a…

SQL Server | SQL Server Transact-SQL
asked 2025-09-05T07:45:01.7866667+00:00
博雄 胡 705 Reputation points
accepted 2025-10-28T12:39:44.5833333+00:00
博雄 胡 705 Reputation points
1 answer

Requirements for SQL connection testing

『In the SQL connection test, Windows authentication can connect, but SQL Server authentication cannot connect』

SQL Server | Other
asked 2025-09-29T09:15:10.82+00:00
k ogawa 0 Reputation points
commented 2025-10-28T12:36:47.83+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
0 answers

How to change SQL Server Instance from running to start?

I am trying to open PCM600 for writing to relays. When trying to open the pop up that show is PCM600 has encountered a problem. SQL Server instance not found. Verify that SQL Server is installed and running. Not sure what I am supposed to do. I go into…

SQL Server Database Engine
asked 2025-10-28T12:08:30.0033333+00:00
Donald Rutledge [EXT] 0 Reputation points
1 answer

Error al instalar sql server 2022 standar edition

Buenos días, al intentar instalar me sale ese error. Se descargo desde la misma plataforma de Microsoft.

SQL Server Database Engine
asked 2025-09-03T15:53:32.8566667+00:00
Héctor Oré 0 Reputation points
commented 2025-10-28T11:48:14.37+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
1 answer

Is this correct SQL query related forum

Hi Just wondering if this is the forum where I can ask SQL queries related questions? Sorry bit confused between other Tech forum.

SQL Server | SQL Server Transact-SQL
asked 2025-09-07T10:38:14.43+00:00
LathaSree 5 Reputation points
commented 2025-10-28T11:22:01.6+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
1 answer

select query

declare @tmp table ( id INT IDENTITY(1,1), Summary varchar(500), type varchar(10), filename varchar(500) ) INSERT INTO @tmp select 'xxx', 'PDF', 'FileName1' union all select 'yyy', 'PDF', 'FileName2' union all Select 'yyy', 'MSG', 'filename3' union…

SQL Server | SQL Server Transact-SQL
asked 2025-09-05T17:23:44.97+00:00
Spunny 366 Reputation points
commented 2025-10-28T11:19:29.85+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
0 answers

MS SQL Server on M.2 NVMe

Maybe somebody is willing to give some help. I have a web server. I thought the best way to give it a bit of extra guts, is to install a high-speed M.2 NVMe SSD. I used a PCI card. All goes well until I try and install SQL server. That fails. I have…

SQL Server Database Engine
asked 2025-09-24T06:55:06.9033333+00:00
Herman Badenhorst 35 Reputation points
commented 2025-10-28T11:02:45.51+00:00
Thumu Sai Pranay 0 Reputation points Microsoft External Staff Moderator
1 answer

SHOULDNT WE USE sql SERVER ON WINDOWS 11 HOME

I WANTED TO KNOW IF SHOULDNT USE SQL SERVER ON WINDOWS 11 HOME , I CALLED SUPPORT FOR A SAVED FILE IN PHONE LINK , WHICH IS SCRAP , I WAS ASKED HOW I AM USING SQL SERVER ON WINDOWS 11 HOME ITS COMMERCIAL , THEN I TOLD I AM USING FOR EDUCATIONAL PURPOSE…

SQL Server | Other
asked 2025-09-19T12:43:38.5266667+00:00
jayaprakash reddy g k 0 Reputation points
commented 2025-10-28T10:48:21.8533333+00:00
Shruti Dhruv 100 Reputation points Microsoft External Staff Moderator
3 answers

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

SQL Server Database Engine
asked 2025-08-05T14:53:19.4333333+00:00
anna@tec 0 Reputation points
commented 2025-10-28T10:45:13.5566667+00:00
anna@tec 0 Reputation points
1 answer

SQL Server Reporting Services 2022 report works but subscription refuses parameter input

A report published to SSRS 2022 works fine. The choices for the parameters are shown, can be selected, and the report output is as expected. When a subscription is created for the same report, entry is refused for the second parameter. The mouse cursor…

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,101 questions
asked 2025-09-19T18:37:55.26+00:00
billvo 0 Reputation points
answered 2025-10-28T10:31:02.3233333+00:00
Shruti Dhruv 100 Reputation points Microsoft External Staff Moderator
1 answer

AT TIME ZONE - GMT Standard Time - Windows [Bug]

Hi, On Windows, SQL Server "AT TIME ZONE" uses the Windows Registry to determine time zone conversion. However, daylight savings conversions in the "GMT Standard Time" time zone on Windows become inaccurate and problematic from years…

SQL Server Database Engine
asked 2025-10-24T09:57:17.63+00:00
Alexander Ali 0 Reputation points
commented 2025-10-28T10:30:16.7866667+00:00
Alexander Ali 0 Reputation points
1 answer

how to fix this error in SSMS error 40

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,356 questions
asked 2025-09-11T21:44:33.4533333+00:00
By becoming a member 0 Reputation points
commented 2025-10-28T09:32:31.6633333+00:00
K Durga Prasanna 5 Reputation points Microsoft External Staff
1 answer

how to fix this error, SQL Server 2022 Developer Edition Oops ... Unable to install SQL Server (setup.exe) Exit code (Decimal): -2147467259Error description: The system cannot find the path specified SQL SERVER INSTALL LOG FOLDER C:\Program Files\Microsof

Detail.txt, Summary.txt, here are two file please help me anyone to fix this error, i have installed SQL server developer version

SQL Server | Other
asked 2025-09-08T13:35:43.45+00:00
Md Abdul Shukoor 0 Reputation points
commented 2025-10-28T09:29:26.57+00:00
K Durga Prasanna 5 Reputation points Microsoft External Staff
2 answers

SQL standard server licensing question

Greetings, We are looking to set up a cost effective VM with MSSQL for a project with 2 concurrent users. This is hosted in a research cloud so we are confused about what license can be used. The research cloud is not listed under microsoft's authorised…

SQL Server | Other
asked 2025-10-24T03:07:28.9566667+00:00
Sean Lo 0 Reputation points
commented 2025-10-28T09:23:33.2233333+00:00
Lakshmi Narayana Garikapati 555 Reputation points Microsoft External Staff Moderator