14,737 questions
2 answers
Clarification on ESU cost for SQL Server 2016 on Windows Server 2016 in Azure VMware Solution
Hi, I’m looking for clarification regarding Extended Security Updates (ESUs) for workloads running in Azure VMware Solution (AVS). Based on the documentation, ESUs are described as being free of charge in Azure environments, including AVS, when…
SQL Server | Other
asked 2026-05-06T09:29:09.9266667+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, 52%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
InfraSolutions
811
Reputation points
answered 2026-05-06T10:15:18.2466667+00:00
InfraSolutions
811
Reputation points
1 answer
Claim space for TempDB on Sql Server
Dear Team, Dose Someone kindly advise how to shrink teamdb with effective way without affect Database Service ?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
699 questions
asked 2026-05-06T03:12:42.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(201.6, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Veasna Lay
0
Reputation points
commented 2026-05-06T07:29:46.7166667+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(108.80000000000001, 66%, 20%)' 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)
博雄 胡
745
Reputation points
1 answer
SSIS 2019/2022 - Teradata 20.00 - Microsoft Teradata Connector - Source and Destination not showing in SSIS Toolbox after installation
I have to upgrade to Teradata 20.00 and cannot get the Teradata Source and Destination Tools to show up in SSIS 2022 with VS2022. I have tried with the packages targeting 2019 and 2022. The installation of the connector itself claims to have been…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,790 questions
asked 2026-04-29T15:20:20.2533333+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(128, 57.99999999999999%, 22%)' 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)
Susann
0
Reputation points
commented 2026-05-06T06:32:11.96+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
3 answers
To Implement HA strategy require licensing Cost
HI Team, We are planning to implement SQL Server 2025 Enterprise Edition with Always On HA and would like to understand the complete licensing cost, including per-core pricing details. Could you please assist with this? Thanks Sadiq
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
699 questions
asked 2026-05-05T10:06:08.2233333+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(249.60000000000002, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sadiq Ali
0
Reputation points
answered 2026-05-06T00:40:25.6066667+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
83,821
Reputation points
2 answers
Issues with SSIS packages after upgrading SQLServer from 2019 to 2022.
These packages have been running successfully for years, but failed after upgrading SQLserver to 2022. Further detail: the package contains a Script task (VB) that creates and populates files on the file system (either excel or PDF). We have two…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,790 questions
asked 2026-04-28T18:10:56.7+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, 99%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Ben Pflanzer
0
Reputation points
recommended 2026-05-05T20:13:07.61+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
3 answers
Tell me most used SQL server administration tools and some examples
I need to cover the most commonly used tools for administering SQL Server, such as SSMS, Azure Data Studio, sqlcmd, etc., along with practical examples of how each tool is used. Could anyone provide an overview of the most popular SQL Server admin tools…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
699 questions
asked 2026-04-29T22:12:54.1066667+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(220.8, 67%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
Gurdeep Vaidya
0
Reputation points
answered 2026-05-05T05:09:52.8+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(112.00000000000001, 21%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Gade Harika (INFOSYS LIMITED)
2,765
Reputation points Microsoft External Staff
4 answers
STAR Schema Model Design
Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
699 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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
I'm using SQL Server 2025, with SSMS V22.5.2, and the Maintenance Plan Wizard is grayed out.
I'm running into the problem of the SQL Server Maintenance Plans options being grayed out. I've gone thru the "common reasons" for this and eliminated those issues. I'm using SQL Server 2025 Standard, V 17.0.1110.1, with SSMS V22.5.2. SSIS,…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,790 questions
asked 2026-05-04T20:29:51.49+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(272, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Keith Vollero
81
Reputation points
edited a comment 2026-05-04T21:24:31.9+00:00
Keith Vollero
81
Reputation points
3 answers
One of the answers was accepted by the question author.
Breaking Changes - SQLOLEDB to MSOLEDBSQL/MSOLEDBSQL19 (SQL OLE DB Provider to SQL OLE DB Driver)
Hello. Very much behind the times, one of our clients needs to migrate their applications from using SQLOLEDB to MSOLEDBSQL or better MSOLEDBSQL19 (i.e. the original OLE DB Provider for SQL Server to the latest OLE DB Driver 19 for SQL Server). …
SQL Server | Other
14,737 questions
asked 2022-11-08T10:56:14.397+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(188.79999999999998, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Clive Crocker
66
Reputation points
commented 2026-05-04T20:52:22.6366667+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
SQL connection open failed when using MS OLE DB Driver 19 for SQL Server
Hi Team, Uninstalled the older version of "Microsoft® OLE DB Driver 18 for SQL Server®" and installed the latest "OLE DB Driver 19.0 for SQL Server". Testing the connection using OLE DB Driver 19 driver then getting the following…
SQL Server | Other
14,737 questions
asked 2022-04-05T09:09:15.577+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(131.20000000000002, 25%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Suresh Kaushik
21
Reputation points
commented 2026-05-04T14:10:24.1433333+00:00
Andrew Jakobs
25
Reputation points
1 answer
One of the answers was accepted by the question author.
Account Combiner looked like it worked but no $ amounts showing
User did account combiner but the dollar amounts are not showing. They did a Financial> Utilities> Reconcile> Year on just the open year, 2026, and this brought the amounts back. Do you think it is okay to do it on the Historical years? Any…
SQL Server | Other
14,737 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(38.4, 61%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
0 answers
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
14,737 questions
asked 2026-04-29T12:20:04.25+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, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Parag Nimbhore
0
Reputation points
commented 2026-05-04T12:03:14.98+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
1,820
Reputation points Microsoft External Staff
Moderator
2 answers
How to activate SQL 2025 license on SQL2022
Hello i bought "SQL Server 2025 Standart sürümü Kalıcı 1 Sunucu Lisansı ve CAL 10".Before i bought this license, i talked with two microsoft sale representative. They confirm that i can use this SQL 2025 license on SQL 2022. But when i try to…
SQL Server | Other
14,737 questions
asked 2026-04-28T08:19:07.6033333+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(16, 78%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Batuhan Demirkiran
0
Reputation points
commented 2026-05-04T11:46:31.6+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
sql 2022 EXPRESS SDCO Error
Hello. i am having issue with installing SQL express 2022. basically i have a program that i am installing, but in the pre-req for that program i have to install sql 2022. while installing i get setup bootstrap error and in logfiles i see…
SQL Server | Other
14,737 questions
asked 2026-04-27T17:11:44.5566667+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, 80%, 27%)' 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)
aa
0
Reputation points
commented 2026-05-04T11:45:16.2033333+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
How to find a claims utilization report
I need a claims utilization report for a small business group
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,156 questions
asked 2026-04-24T17:37:35.7466667+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(243.2, 63%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Gilbert, Lawrence N
0
Reputation points
commented 2026-05-04T11:44:10.56+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
transactional replication between non-domain servers
Hi all, I have two sql server database servers. These are on the same network but there is no domain server. Can I configure these servers for transactional replication ? I know this is possible but how? Any document do you have to do this? Any…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
699 questions
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK
261
Reputation points
commented 2026-05-04T11:43:17.23+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
2 answers
Alternative to UNION
I have a UNION Query that is combining information from a History Table and the current Master Table. We are talking about a few million rows here. The problem is the amount of [tempdb] space it is allocating and using for the UNION. So we thought if we…
SQL Server | SQL Server Transact-SQL
283 questions
asked 2026-04-22T20:14:11.0866667+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
271
Reputation points
commented 2026-05-04T11:42:16.46+00:00
Lakshmi Narayana Garikapati
1,310
Reputation points Microsoft External Staff
Moderator
1 answer
SSIS Package Fails with System.Data.SQLite Could Not Load Error (E_POINTER)
I have deployed an SSIS project using an .ispac file into SSISDB. The project contains Cdata Odoo components and Kingswaysoft toolkit. When I try to execute the package (both from SSISDB and from Visual Studio), it fails with the following…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,790 questions
asked 2026-04-29T06:12:42.41+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, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
Ishika Raiyani
20
Reputation points
commented 2026-05-04T10:40:07.5066667+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
2 answers
ERROR 1067
I'M GETTING AN ERROR MESASGE 1067 WHEN I TRIED INSTALLING A PROGRAM. a SQL IS NOT STARTING. I TRIED STARTING IT IN THE SYSTEM ANDTHAT DID NOT WORK.
SQL Server | Other
14,737 questions
asked 2026-04-28T18:24:02.25+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(99.2, 91%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dan Kilpatrick
0
Reputation points
commented 2026-05-04T10:12:18.5433333+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
1 answer
BULK INSERT cannot access UNC path, error code 5 (Access is denied) using gMSA unless locally triggered
Running a stored procedure to bulk insert from a UNC path works locally via SSMS and via SQL agent job but if run remotely I receive Operating system error code 5 (access is denied). Please help as this workaround is not suitable for our…
SQL Server | SQL Server Transact-SQL
283 questions
asked 2026-04-28T02:03:11.9766667+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(185.6, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Michelle
0
Reputation points
edited a comment 2026-05-04T06:09:55.16+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator