SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
1 answer
Why does sys.dm_db_log_space_usage.used_log_space_in_bytes keep increasing with Simple recovery model
I have a simple database with essentially only one active table, though it is a large one. It is for app analytics. A bunch of records are inserted every few seconds. It is searched a few times every day. That is all of its use. Its recovery model is…
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(256, 0%, 34%)' 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)
1 answer
One of the answers was accepted by the question author.
I am trying to create a database and getting a 262 error.
I am on the admin account of my personal computer, and my instructor in the course I'm taking told me to right click the SSMS 22 icon and run it as an admin, so I did that first, and I'm still getting the same error. It seems to me that I don't have…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2026-08-26T17:18:59.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(144, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Krista Bland
0
Reputation points
commented 2026-08-26T18:47:04.66+00:00
Krista Bland
0
Reputation points
1 answer
Partition elimination on SQL Server 2025 running on Azure VM querying files in Storage Account
I'm trying to get partition elimination to work when using OPENROWSET on SQL Server 2025 running on an Azure VM and querying files in an Storage Account with Hierarchical namespace enabled. I have no more ideas how to get it to work. My starting point…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
290 questions
asked 2026-08-23T14:42:19.6566667+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, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jerry Rausk
20
Reputation points
answered 2026-08-26T18:40:28.5533333+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(121.6, 19%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHQ%3C/text%3E%3C/svg%3E)
Hugo Queiroz
81
Reputation points Microsoft Employee
1 answer
SQL Server 2022 reports a unique index violation for a non-unique index
Under SQL Server 2022, an intermittent 2601 error occurs during a scheduled data load. SQL Server reports a duplicate key violation on a non-unique index, while referring to the index as a unique index. Another anomaly is that the duplicate key reported…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-25T06:30:09.3433333+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, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZN%3C/text%3E%3C/svg%3E)
Zalán Kovalcsik
0
Reputation points
commented 2026-08-26T17:42:49.3033333+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, 63%, 13%)' 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)
Deepesh Dhake
840
Reputation points
1 answer
Failed to install Microsoft Sql server latest version.
I have bought a laptop named ASUS gaming TUF A15. I am trying to install SQL server latest version but failed every time. I contacted ASUS for this. They said this is a third-party application. they are not responsible for this. You need to connect…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-26T12:37:14.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(86.4, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ranjan Majumder
0
Reputation points
commented 2026-08-26T16:57:23.2633333+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
Help needed: SQL Server 2014 fails to start with error "Stack Overflow Dump not possible"
ERRORLOG.logHi! An instance of MS SQL Server 2014, which is installed on Windows 11, started failing during startup. The only error message I can see is "Stack Overflow Dump not possible". Any ideas, what's the matter here and how to solve…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2025-09-19T06:46:09.94+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(57.599999999999994, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Michael Antes
0
Reputation points
commented 2026-08-26T16:38:12.37+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
How to fix Error 262 in Microsoft SQL Server?
TITLE: Microsoft SQL Server Management Studio Create failed for Database 'deneme'. (Microsoft.SqlServer.Smo) For help, click:…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2023-09-18T10:30:01.8733333+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, 48%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Şevval Çakır
0
Reputation points
commented 2026-08-26T16:30:59.8066667+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
1 answer
SQl Services not starting after installing CU3 on SQL 2025
I have installed SQL Pacth on Failover cluster instance for SQL 2025. After installing , SQL Services are not coming up. Error Error message - Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql'…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-26T09:31:21.2866667+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, 19%, 27%)' 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)
Abhishek Gaddam
0
Reputation points
commented 2026-08-26T14:13:39.2066667+00:00
Abhishek Gaddam
0
Reputation points
4 answers
One of the answers was accepted by the question author.
filepath() and filename() causes syntax error in SQL Server 2025 and external table
We are currently running in SQL Server 2022 and use external tables on top of parquet files in a storage account. All the external table definitions looks something like this CREATE EXTERNAL TABLE [my_external_data] ( [column_a] [varchar](20)…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
290 questions
asked 2026-08-21T11:26:39.3133333+00:00
Jerry Rausk
20
Reputation points
commented 2026-08-26T07:49:01.45+00:00
Jerry Rausk
20
Reputation points
7 answers
One of the answers was accepted by the question author.
Download link for Microsoft.ACE.OLEDB.12.0
We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,805 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2024-04-19T14:09:09.57+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, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
60
Reputation points
commented 2026-08-26T04:29:46.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(275.2, 7.000000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nkrumah Richards
0
Reputation points
1 answer
Changing account password in active directory - SQL accounts
I might need to change the password of an account in active directory. I have several instances of SQL express running various programs, SharePoint being one of them. How can I verify which accounts those SQL instances depend on and if it is on that…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2026-08-25T17:08:23.1033333+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(163.2, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Susan Dodds
396
Reputation points
commented 2026-08-25T22:50:44.8266667+00:00
Deepesh Dhake
840
Reputation points
1 answer
New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)
SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-21T14:07:13.2433333+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, 98%, 31%)' 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)
Hubert
0
Reputation points
commented 2026-08-25T21:14:05.1566667+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
Performance regression von SQL Server 2022 to 2025
We have the following scenario we could reproduce on a single/same Windows Server 2019: Microsoft SQL Server 2025 (RTM-CU8) (KB5104822) - 17.0.4075.5 (X64) - Enterprise Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64>…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-25T13:33:21.3933333+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(51.2, 1%, 14%)' 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)
Patrick Simons2
15
Reputation points
commented 2026-08-25T18:05:53.39+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
3 answers
Access issue due to sa account
Hi, To issue Microsoft OLE DB Provider for SQL Server Cannot open database "hMailserver" requested by the login. I can logon on SSMS using the same sa account. I am using Sql server 14.0.1000. Any reason?
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,805 questions
asked 2026-08-21T09:24:27.23+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, 97%, 40%)' 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)
Jonathan
300
Reputation points
commented 2026-08-25T12:36:59.2466667+00:00
Erland Sommarskog
136.8K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Version 2022 Expired
Hi team, My free lab kit has expired therefore I am unable to launch SCCM console because it is unable to connect to database. I tried clean reisntallation of the lab but it shows expired. Can you please guide me how I can upgrade my SQL from Evaluation…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2026-08-24T11:00:00.5766667+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' %3ESM%3C/text%3E%3C/svg%3E)
Syed Mehdi
0
Reputation points
commented 2026-08-24T21:02:38.6933333+00:00
Syed Mehdi
0
Reputation points
2 answers
How to prevent auto-update of SQL Server 2025 Engine?
Hi. I am convinced of a JSON bug introduced somewhere between CU4 and CU6. I want to reinstall my instances so I can troubleshoot and then post the bug if it exists. I have repeatedly uninstalled my SQL Server 2025 instances. I have reinstalled 3 RTM…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 questions
asked 2026-08-20T16:21:39.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(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Foushee
96
Reputation points
edited an answer 2026-08-24T02:54:33.0366667+00:00
Deepesh Dhake
840
Reputation points
2 answers
SQL ISNT RESPONDING
I USE SSMS SO IN SQL THE PREVIOUS QUERIES GET EXECUTED ALSO THE NEW ONES TOO . BUT WHEN I MODIFY THE PREVIOUS QUERIES THE RESULT REMAINS THE OLD SAME .THEN AFTER THE FEW TIME PERIOD THE SAME PROBLEM HAPPENS TO THE NEW QUERIES THAT I EXECUTED. EVEN AFTER…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2026-08-22T12:24:23.3733333+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, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Maninder Karjee
0
Reputation points
answered 2026-08-23T04:06:16.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(208, 52%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
Rukshan edirisinghe
85
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL connection failed with SSMS on workgroup when using FQDN
Hello, When I try to connect locally (or remotely) with SSMS on my SQL server with hostname "localhost" or "hostname" it works fine. However, if I try with "hostname.domain.com" it doesn't work I have error 18452 (Login…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
769 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(182.40000000000003, 32%, 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)
4 answers
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,800 questions
asked 2024-04-23T12:11:55.2666667+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(156.8, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Betselot Getahun
0
Reputation points
edited the question 2026-08-21T20:23:42.5466667+00:00
Gérard Oomens
130.1K
Reputation points
Volunteer Moderator
1 answer
How to see reason code of stock adjustments
How do I generate a report where I can see adjustments to the Item Ledger Entries and the reason code used to adjust the items?
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,175 questions
asked 2026-07-14T14:09:01.0433333+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(3.2, 95%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Daren Ali
0
Reputation points
answered 2026-08-21T19:06:39.41+00:00
Karen Lopez
81
Reputation points MVP
Volunteer Moderator