276 questions
3 answers
Copying a 32-Million Row Table From Production Server to Test Server
So we believe we're having tempdb issues with a very wide table that has 32-Million Rows on it. There is no Primary Clustered Index, No Indexes defined on it at all. We have tried an INSERT SELECT going across a Linked Server to our Test Server to copy…
SQL Server | SQL Server Transact-SQL
asked 2026-03-13T19:43:14.18+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
251
Reputation points
answered 2026-03-14T23:14:43.6533333+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,661
Reputation points
Volunteer Moderator
2 answers
In place Upgrade from Sql 2014 to 2022
Hello, I am planning to perform Sql server 2014 to 2022 on Windows server 2022. I have done following before upgrade: Verified Sql server 2014 is at SP3 Done Assessment and nothing breaking change except depreciated datatype. We will be taking…
SQL Server | Other
14,704 questions
asked 2026-03-13T21:38:57.79+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(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)
pdsqsql
436
Reputation points
commented 2026-03-14T21:48:58.93+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
Upgrade sql 22 to 25 ends with error Azure extension for SQL Server Failed
I have just upgraded my sql 2022 to 2025, everything went OK except at the end, I got an error as follows Feature: Azure extension for SQL Server Status: Failed Reason for failure: An error…
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.
605 questions
asked 2026-03-14T12:47:40.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(64, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Salam ELIAS
257
Reputation points
commented 2026-03-14T18:43:32.5266667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
Is sql copilot free or is a commercial option
When I clik on Copilot in SSMS it asks me for some input like endpoints, does this mean that it is not free? Thanks
SQL Server | Other
14,704 questions
asked 2026-03-14T12:49:39.1466667+00:00
Salam ELIAS
257
Reputation points
answered 2026-03-14T13:34:43.1066667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
1 answer
How to reset Local Database
My computer is saying local data base must be reset
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
664 questions
asked 2026-03-13T14:59:56.87+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, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
StorTropolis - Tiffany Springs
0
Reputation points
commented 2026-03-14T04:04:23.43+00:00
Viorel
126.7K
Reputation points
2 answers
Integration with SSO login on-premises (non-fabric and non-cloud) PowerBI Reporting Server
Hi, We need to understand the standard integration process of integration SSO login (with PowerBI Reporting Server) wherein the flow is following : FSSO login happens and a SAML token is generated by the service provider. Using above SAML token, we…
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,143 questions
asked 2026-03-02T09:59:16.6233333+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(35.2, 90%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Samir Modi
0
Reputation points
commented 2026-03-13T15:30:08.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(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
920
Reputation points Microsoft External Staff
Moderator
2 answers
error 26 trying to connect to my local server
Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…
SQL Server | Other
14,704 questions
asked 2026-03-06T18:06:48.76+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(278.4, 85%, 36%)' 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)
Chau Nguyen (CELA)
0
Reputation points Microsoft Employee
commented 2026-03-13T15:25:18.61+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
2 answers
How to identify different compressions
Hi, ALL, This - https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-partitions-transact-sql?view=sql-server-ver17 indicates that there is only 1 record for both XML and regular partition compression. My question would be -…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
664 questions
asked 2026-03-06T06:53:26.0633333+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, 3%, 24%)' 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)
Igor Korot
56
Reputation points
commented 2026-03-13T15:24:00.12+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Object Explorer closes immediately in Visual Studio – Error 0x8007007B and SQL Server Express installation fails
Details: I am experiencing an issue with Visual Studio where I cannot create or manage databases. When I open Visual Studio and go to View → SQL Server Object Explorer, a popup window briefly appears and then immediately closes again. This keeps…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
664 questions
asked 2026-03-05T20:16:13.1566667+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, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Søren Dyrbye
0
Reputation points
commented 2026-03-13T15:22:35.6833333+00:00
Lakshmi Narayana Garikapati
920
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Best, Most Efficient DATETIME filtering
I have seen many discussions regarding doing filtering against a DATETIME Data Type. Some suggest to use a true DATTETIME format. WHERE <DATETIME_Column_Name> >= '2026-02-17 00:00:00.000' Others suggest to use just a quoted Date... WHERE…
SQL Server | SQL Server Transact-SQL
276 questions
2 answers
SQL Server 2025 LocalDb installation is missing components
According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
664 questions
asked 2025-12-09T15:15:18.17+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(236.8, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Duncan Smart
0
Reputation points
commented 2026-03-13T13:34:39.3433333+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
TSQL query to dynamically extract data from a json object using OPENJSON in SQL
Hi everyone. I need help with writing a TSQL query that will dynamically extract data from a JSON object using OPENJSON. I need the query to be able to work on both simple and nested json object. Thanks in advance.
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,715 questions
SQL Server | Other
14,704 questions
asked 2021-11-25T04:33:27.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(281.6, 57.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETO%3C/text%3E%3C/svg%3E)
Thelma Obirieze
66
Reputation points
edited an answer 2026-03-13T13:27:50.87+00:00
Thelma Obirieze
66
Reputation points
1 answer
One of the answers was accepted by the question author.
Please provide KB2000257
I would like to read the KB2000257 article. SQL Server Express 2022 is failing per the 3 local security policies error BUT the 3 policies are all set correctly! The failure is immediate and NO LOGS are produced yet.
SQL Server | Other
14,704 questions
asked 2026-03-12T16:18:45.61+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(118.4, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Phelan, Susan - FARMINGTON CT
20
Reputation points
accepted 2026-03-13T13:10:36.4933333+00:00
Phelan, Susan - FARMINGTON CT
20
Reputation points
2 answers
SQL Agent Job failing with Error 8152 (String or binary data would be truncated) during Replication/Distribution
Hi everyone, I am encountering a persistent failure in a SQL Server Agent Job that appears to be related to a Replication Distribution Agent. The Error: The job fails at Step 1 (Distribution Agent startup) or Step 3 (Detect nonlogged agent shutdown) with…
SQL Server | Other
14,704 questions
asked 2026-03-12T19:52:40.2633333+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, 59%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ramya
0
Reputation points
answered 2026-03-12T22:11:33.0133333+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
How to create initial full backup followed by transaction logs daily?
This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…
SQL Server | SQL Server Transact-SQL
276 questions
asked 2026-01-30T18:06:58.63+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(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
980
Reputation points
commented 2026-03-12T22:01:04.1566667+00:00
Erland Sommarskog
133.2K
Reputation points MVP
Volunteer Moderator
2 answers
SSAS 2019 - Tabular Process Hanging / Deadlocking
Hello everyone, We have a SSAS 2019 CU16 hosting a very small tabular model, about 20-25 tables and only a couple MB in size. As expected the processing time is fairly short, only 2-3 seconds so we currently have an SQL Agent job (on a remote…
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,368 questions
asked 2022-08-17T12:30:07.243+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(6.4, 42%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JML
16
Reputation points
commented 2026-03-12T15:50:18.14+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, 86%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mathieu Daigle
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Enabling RCSI and ADR on SSISDB and ReportServer
We're considering enabling two database-level settings on SSISDB and ReportServer: READ_COMMITTED_SNAPSHOT (is_read_committed_snapshot_on = 1) — reduces blocking by using row versioning instead of shared locks ACCELERATED_DATABASE_RECOVERY…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
asked 2026-02-24T22:16:48.07+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(195.2, 11%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Louis Davidson
41
Reputation points
accepted 2026-03-12T14:11:56.5433333+00:00
Louis Davidson
41
Reputation points
1 answer
When following SSIS Tutorial on microsoft learn I receive a data type error
I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,778 questions
SQL Server | Other
14,704 questions
asked 2024-07-31T10:19:36.55+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(64, 22%, 16%)' 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)
Adam
0
Reputation points
commented 2026-03-12T14:07:44.4033333+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(313.6, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Peter Schellhardt
0
Reputation points
2 answers
Sequel server licensing
My distributer is telling me that SQL Server Standard 2022 - 2 Core License Pack - 3 yearSQL Server Standard 2022 - 2 Core License Pack - 3 year billed annually is a perpetual license? I have query with this as it has a termed subscription time?…
SQL Server | SQL Server Transact-SQL
276 questions
asked 2026-03-02T03:07:55.3166667+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(137.6, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Esther Cleave
0
Reputation points
answered 2026-03-12T10:04:27.2266667+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,570
Reputation points Microsoft External Staff
Moderator
2 answers
ACE.OLEDB.12.0 provider is not registered on the local machine
Hello, We have a client that tried to import an excel using the import and export wizard and he recceived the following error: The operation could not be completed. Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
664 questions
asked 2026-03-04T07:35:23.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(108.80000000000001, 63%, 20%)' 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)
Admin Team TGS
0
Reputation points
commented 2026-03-12T07:25:46.3966667+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