457 questions
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 74%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
anna@tec
0
Reputation points
commented 2025-11-01T10:30:46.9866667+00:00
Erland Sommarskog
127.7K
Reputation points MVP
Volunteer 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
243 questions
asked 2025-09-05T17:23:44.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 43%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Spunny
366
Reputation points
commented 2025-11-01T07:20:08.1933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 39%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Thumu Sai Pranay
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
243 questions
asked 2025-09-07T10:38:14.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 13%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LathaSree
5
Reputation points
commented 2025-11-01T07:19:19.0533333+00:00
Thumu Sai Pranay
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Server Developer Edition usage for local development environment
Details Hello, We are a corporate user of SQL Server Enterprise Edition for our production workloads. For local, non-production development work, our developers and citizen developers often install SQL Server Developer Edition on their individual Windows…
SQL Server | Other
14,569 questions
asked 2025-10-30T22:05:53.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
최종호
0
Reputation points
answered 2025-10-31T22:56:24.61+00:00
Erland Sommarskog
127.7K
Reputation points MVP
Volunteer Moderator
0 answers
SQL Server 2022, Visual Studio 2022 - Microsoft VB 2022 script task interacting with Excel COM Errors
We have some SSIS packages that interact with Excel files. The SSIS packages output the data to the excel spreadsheets that include a template row so that numbers are formatted as numbers.. etc. There are also pivot tables that exist on other tabs of…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,749 questions
asked 2025-10-31T20:27:55.9566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Guilfoy, Kristy
20
Reputation points
asked 2025-10-31T20:27:55.9566667+00:00
Guilfoy, Kristy
20
Reputation points
2 answers
How to fix sql server job schedules
How do we fix the issue when the sql agent job schedules are updated but do not run using the new schedule? We have a Microsoft SQL Server 2019 (RTM-CU32) (KB5054833) - 15.0.4430.1 (X64) instance. whenever we try to adjust an existing job schedule it…
SQL Server Database Engine
457 questions
asked 2025-10-30T14:01:00.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 11%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jamie Greiver
0
Reputation points
answered 2025-10-31T19:26:45.05+00:00
Erland Sommarskog
127.7K
Reputation points MVP
Volunteer Moderator
1 answer
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
457 questions
asked 2025-09-15T06:45:23.0233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 97%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%3C/text%3E%3C/svg%3E)
24551988
25
Reputation points
recommended 2025-10-31T19:15:09.7+00:00
Erland Sommarskog
127.7K
Reputation points MVP
Volunteer Moderator
1 answer
Trying to create a SSMS extension for autocomplete...
Hi everyone, I’m building an SSMS extension to provide a custom autocomplete experience, beyond the built-in IntelliSense. What I’m aiming for Offer multiple completion options. Allow refreshing/changing the suggestion sources via toolbar/menu…
SQL Server | Other
14,569 questions
asked 2025-10-29T20:31:49.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 36%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Maximiliano Schmidt
0
Reputation points
commented 2025-10-31T13:29:36.5133333+00:00
Maximiliano Schmidt
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How to connect to Mysql
How can i connect to Mysql database in SSIS package？
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,102 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,749 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
SQL Server 2025 Azure open AI Vector Embedding for ai_generate_embeddings
Hi Team, Currently I am trying to implement Vector Search using SQL Server 2025 and SSMS 21. For getting embeddings I am trying below code using ai_generate_embeddings, however i am getting empty embeddings. Code : Creating Credentials CREATE DATABASE…
SQL Server Database Engine
457 questions
asked 2025-09-13T12:11:13.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 92%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harshala
0
Reputation points
commented 2025-10-31T12:09:36.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 6%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
1 answer
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
457 questions
asked 2025-09-03T08:56:40.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 44%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jakob Hommelhoff
0
Reputation points
commented 2025-10-31T12:08:49.26+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
1 answer
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to detect and mitigate…
SQL Server Database Engine
457 questions
asked 2025-09-18T07:36:26.6366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
291
Reputation points
commented 2025-10-31T12:06:08.72+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Performance Issue: Extremely Long Time to Add Large TDE-Encrypted Database to Cross-Site Availability Group
We are experiencing significant delays when adding large databases (4TB+) encrypted with Transparent Data Encryption (TDE) to an Availability Group replica servers using scripts. This operation takes an unacceptably long time is this an expected…
SQL Server Database Engine
457 questions
asked 2025-09-21T09:36:17.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mona Seddik
0
Reputation points
commented 2025-10-31T12:05:10.6633333+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Faster way to restore a MSSQL DB hosted on storage spaces.
Problem Summary We need a faster way to restore SQL Server Always On Availability Groups (AGs) that use Windows Storage Spaces, with each database on its own pool, from Nutanix app-consistent storage snapshots. Challenge Even with a per-DB pool, a…
SQL Server Database Engine
457 questions
asked 2025-09-22T07:17:43.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 87%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tinku Kumar
0
Reputation points
commented 2025-10-31T12:04:23.6433333+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
1 answer
How to Patch SQL Server from CU+GDR 18 to CU+GDR32
Hi All, We have a SQL Server currently running: Version: RTM-CU18-GDR (KB5021124) – 15.0.4280.7 (x64) OS: Windows Server 2019 Standard Build 17763 We need to patch this server to the latest release (CU32 + GDR 15.0.4445.1). My question: Can we upgrade…
SQL Server Database Engine
457 questions
asked 2025-09-15T04:05:20.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 68%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Md Himel Mahmud
20
Reputation points
commented 2025-10-31T12:02:33.87+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
0 answers
SQL server 2022 job fails
Hello SQL Server 2022 16.0.4212.1 Installed in a windows server 2025 DC. SQLSERVERAGENT starts with NT Service\SQLSERVERAGENT I have some jobs that runs at the scheduled times. But one no. Failure: "Job failed. The job was invoked by Schedule 9…
SQL Server | SQL Server Transact-SQL
243 questions
asked 2025-09-11T07:43:40.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 10%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Delmira Oliveira
100
Reputation points
commented 2025-10-31T11:59:19.2866667+00:00
Nithin Krishna Madadi
0
Reputation points Microsoft External Staff
Moderator
2 answers
SQL Driver for MSSQL 2008 R2 and OpenJDK 17
Hi Guys, I am connecting Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) from RHEL9.6 system having openJDK17 on it but getting below error. I tried with SQL driver version 13,12 and 10 but result is same always. So can you…
SQL Server Database Engine
457 questions
asked 2025-09-04T13:53:49.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 69%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sumit Chaudhary
0
Reputation points
answered 2025-10-31T11:47:51.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 18%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
Tim Lewis
0
Reputation points
1 answer
Veracode scan issues on reportviewer dll files
I have some Veracode scan issues for the following .dll files: microsoft.reportviewer.common.dll CWE ID 331 - Standard random number generators do not provide a sufficient amount of entropy when used for security purposes. Attackers can brute force…
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,102 questions
asked 2025-09-16T01:36:39.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
CHRISTOPHER NATHAN HENDRIS
0
Reputation points
answered 2025-10-31T11:41:51.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 41%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Venkata Ramanamma Uppu (Quadrant Technologies LLC)
0
Reputation points Microsoft External Staff
0 answers
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task. I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,749 questions
asked 2025-10-31T06:27:51.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Uma
466
Reputation points
commented 2025-10-31T11:36:07.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
645
Reputation points Microsoft External Staff
Moderator
1 answer
what is the price for sql server license enterprise edition?
Hi, my organization currently has SQL server standard edition which is going to expire next month. We are planning to upgrade the license to an enterprise version. Can you please help me with the pricing and also the installation guide for upgrade from…
SQL Server | Other
14,569 questions
asked 2025-09-14T23:07:49.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 84%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Apurv Sapar
0
Reputation points
commented 2025-10-31T11:19:08.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinay Kumar Eshwara
5
Reputation points Microsoft External Staff
Moderator