SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
697 questions
5 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
![](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
61
Reputation points
edited a comment 2026-05-04T21:24:31.9+00:00
Keith Vollero
61
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,736 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,736 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,736 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)
2 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
697 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
commented 2026-05-04T12:14:35.1966667+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
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,736 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
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
1 answer
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
commented 2026-05-04T11:53:26.9466667+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
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,736 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,736 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
697 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,736 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
1 answer
Mssql Log Shipping Requirement
I want to know about Mssql Log Shipping requirement to make it and the setup in details
SQL Server | Other
14,736 questions
asked 2026-05-04T02:05:32.8966667+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, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
David Prodata
60
Reputation points
answered 2026-05-04T02:05:54.9433333+00:00
Q&A Assist
1 answer
Information on installation of Security Update for the Microsoft ODBC Driver for SQL Server.
I would like to know more about the installation of Security Update for the Microsoft ODBC Driver for SQL Server. Let us say, I need to install the KB (KB5037571) and I am using Microsoft catalog for downloading the binaries. However, I see many binaries…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
697 questions
asked 2026-01-21T11:46:59.9333333+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(172.8, 10%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Dhanraj D
16
Reputation points
commented 2026-05-03T12:30:42.6333333+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(115.19999999999999, 90%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nicolas Cardenas-Rada
0
Reputation points
2 answers
how to sucessfully connect sql Smm server profile to database engine?
i tried connecting sql 2025 model of server profiler 22 in my system of DESKTOP-UL2OACD BUT its showing TITLE: Connect to Server Cannot connect to DESKTOP-UL2OACD\iwunor kelechi. ADDITIONAL INFORMATION: A network-related or instance-specific error…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
697 questions
asked 2026-05-02T14:05:18.68+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(288, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Iwunor kelechi
0
Reputation points
answered 2026-05-02T20:47:59.19+00:00
Erland Sommarskog
133.9K
Reputation points MVP
Volunteer Moderator
1 answer
sql server migration assistance oracle - accidently select always "words" while creating report. Need a report in HTML
accidently select always "words" while creating report. I need to create report in HTML How to reset this feature
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
606 questions
asked 2026-05-02T17:40:15.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(262.40000000000003, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hussain, Baqir
0
Reputation points
commented 2026-05-02T17:50:23.4866667+00:00
Hussain, Baqir
0
Reputation points