SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
2 answers
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
asked 2026-08-21T20:10:53.5166667+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, 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)
matteu31
512
Reputation points
commented 2026-08-21T21:17:14.66+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
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,796 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
129.8K
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
0 answers
SQL Server Migration Assistant (SSMA) for DB2 v10.5 - crash with "Exception: Win32 handle that was passed to Icon is not valid or is the wrong type."
SQL Server Migration Assistant for DB2 crash. See attached log file.
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.
608 questions
asked 2026-07-21T23:42:45.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(112.00000000000001, 25%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Stephen Landess
0
Reputation points
commented 2026-08-21T19:05:10.9533333+00:00
Karen Lopez
81
Reputation points MVP
Volunteer Moderator
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
764 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
answered 2026-08-21T18:10:16.4066667+00:00
Erland Sommarskog
136.4K
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-21T15:35:47.3166667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
3 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
289 questions
asked 2026-08-21T11:26:39.3133333+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
0
Reputation points
commented 2026-08-21T15:34:58.7866667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
2 answers
Clarification on SQL Server License Compliance during FCI Migration (VMware to Hyper-V)
Hello everyone, I am currently executing an internal infrastructure migration project moving our environment from VMware to Microsoft Hyper-V, and I need some clarification on SQL Server licensing compliance during the transition phase. Current…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-30T16:48:14.3766667+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, 52%, 23%)' 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)
Sang. Truong Tan
0
Reputation points
edited an answer 2026-08-21T12:07:05.3766667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
What are the best practices for improving SQL Server database performance?
I’m learning SQL Server and would like to understand the most important practices for keeping a database performant . Which areas should I focus on first, such as indexing, query optimization, statistics, execution plans, and database configuration?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-19T09:46:58.73+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(259.20000000000005, 40%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Steve John
20
Reputation points
accepted 2026-08-21T10:32:36.46+00:00
Steve John
20
Reputation points
1 answer
AG instance not in sync
We have 8 databases in an instance. All 8 databases are members of Availability Group. On the secondary replica, the whole instance is not synchronizing . Could you please advise how to bring the secondary instance as synchronized Thanks, Chaitanya
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-23T11:50:51.2733333+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
841
Reputation points
answered 2026-08-21T00:13:15.9866667+00:00
Ben Miller-(DBADuck)
285
Reputation points MVP
3 answers
Database refresh from Production to Dev
We want to restore some databases from Production server to Dev server. We want to create a job that automatically restores a fresh copy of these databases to Dev server on 10th of each month. Could you please advise on how to do this.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-06T19:39:45.92+00:00
Chaitanya Kiran
841
Reputation points
answered 2026-08-20T23:59:01.75+00:00
Ben Miller-(DBADuck)
285
Reputation points MVP
1 answer
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
764 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
answered 2026-08-20T21:05:09.9766667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
2 answers
SQL serve Management Studio cannot connect to my server
I am tryng to download SSMS on my laptop to study SQL I have downloaded SQL Server 2019 express I have downloaded the visual studio installer to install SQL server management studio 22 It wont connect to the server I am getting the below error…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-20T03:32:59.0333333+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(192, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lorraine Barron
0
Reputation points
commented 2026-08-20T08:56:48.3666667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
1 answer
stored procedure FillTimesheetListTempTable Pass Through SQL
See attached error. User goes to her Home Page, clicks on the Procurement section and onto Timesheets and immediately gets the attached error. The stored procedure FillTimesheetsListTempTable. Pass Through SQL, returned the following results: DBMS:…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 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
On-prem SQL server needs a Trust certificate
Hello Team, We have on-prem SQL Server which is running from Azure VM. From same Azure VM, we have Gateway running as well. However, we are facing an issue while connecting SQL server with PowerBI desktop and Services. For this issue, PowerBI team has…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-19T18:34:42.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(86.4, 34%, 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)
Hemant
61
Reputation points Microsoft External Staff
answered 2026-08-19T19:35:18.43+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
4 answers
Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True
Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-13T09:22:07.6666667+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(80, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
20
Reputation points
answered 2026-08-19T13:31:03.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(288, 61%, 37%)' 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)
sudhir kumar
0
Reputation points
2 answers
Deleting mysql server 2019 instance configuration and things of that matter.
For one of my college classes I was told to download a sql server 2019 and the ssms 19.3 after I finished that classes I asked my teacher how to uninstall everything but he didn't respond back so I decided to try and delete the stuff myself I didn't…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-14T15:50:17.15+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' %3EJW%3C/text%3E%3C/svg%3E)
Jordan Willingham
0
Reputation points
answered 2026-08-19T13:08:28.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(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
820
Reputation points
2 answers
Alternatives to Crystal Reports for .NET compatible paginated reporting tools?
We're looking at tools for creating paginated reports. We have a couple of parameters: There needs to be up-to-date .NET libraries so we can have run the reports via C# wrappers in our code. Allows for pulling data from SQL Server We're…
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
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 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(118.4, 44%, 21%)' 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)
![](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, 5%, 13%)' 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.
How to auto-detect dead-lock condition
Some time SQL server hang-out due to in sufficient memory or dead lock. How to auto-detect dead-lock condition in SQL server, and I also want a notification email from SQL Agent.
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
289 questions
asked 2026-08-16T09:52:00.07+00:00
Avnish Kumar Mishra
20
Reputation points
accepted 2026-08-19T06:03:13.4366667+00:00
Avnish Kumar Mishra
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Does Microsoft JDBC Driver 12.10 support MSSQL 2025?
Hi All, Does Microsoft JDBC Driver 12.10 for SQL Server support SQL Server 2025 ? Does Microsoft JDBC Driver 12.4 for SQL Server support SQL Server 2025 ? Specific support for SQL Server versions, including MSSQL 2025, is not explicitly mentioned…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-18T03:41:18.2766667+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, 82%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jessy Chen[陳慧臻]
20
Reputation points
accepted 2026-08-19T01:58:14.3766667+00:00
Jessy Chen[陳慧臻]
20
Reputation points