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
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
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
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
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
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
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
Requirements for SQL connection testing
『In the SQL connection test, Windows authentication can connect, but SQL Server authentication cannot connect』
SQL Server | Other
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
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
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
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
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
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
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
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
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
how to fix this error in SSMS error 40
SQL Server Analysis Services
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
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…