SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
2 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)
2 answers
How to recover from and MSDB database in “suspect” mode
Dear community, My SQL server MSDB DB is in suspect mode and i have no backup, i have tried to repair it to no avail, i have also run a full SQL repair which completeted successfully but i still have the error. Please advise on how i can repair…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-29T06:07:27.2133333+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, 46%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rab Processors
0
Reputation points
answered 2026-01-29T22:27:53.45+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
2 answers
Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)
Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS) Microsoft SQL Server Enterprise Developer (64-bit) / Windows 11 Home / We hebben de volgende procedure…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-29T11:22:08.93+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(89.60000000000001, 69%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Patrick LEONARD
0
Reputation points
answered 2026-01-29T22:17:15.0033333+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
DatabaseMail.exe fails after SQL Server 2022 from CU22 to CU23 - Missing Microsoft.SqlServer.DatabaseMail.XEvents.dll
Product: SQL Server 2022 Enterprise Edition Affected Versions: CU23 Component: Database Mail Summary: Database Mail fails to start or send emails after updating to SQL Server 2022 CU23 (also observed on CU22) with error indicating missing assembly…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-19T07:29:32.3466667+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, 28.000000000000004%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Musa YILMAZ
80
Reputation points
commented 2026-01-29T22:08:12.5166667+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
2 answers
How to fix the identity issue in sql server 2025 AI feature while setting up Vector features
I am currently doing POC to explore SQL Server 2025 AI Feature in which I tried to set up Vector features. I am able to create scoped credential and external model but when I do the select statement it gives an error : here is the select state : SELECT…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-21T11:50:19.3833333+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, 16%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Venugopal, Kamalakkannan
0
Reputation points
commented 2026-01-29T21:54:09.89+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
sqlcmd execute issue in SQL Server 2025
EXEC xp_cmdshell 'sqlcmd -S MYS-0101 -d SampleDatabase -U sa -P Sa123 -i "script.sql"' is not working in SQL 2025 its giving trust certificate error, how to fix this certificate error without changing the code I need the microsoft…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-28T16:12:11.7133333+00:00
Ganesh R
0
Reputation points
commented 2026-01-29T21:45:04.5433333+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
1 answer
When I create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script
When I auto-create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script and the values are displayed different to oledb
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-29T09:24:18.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(214.4, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Brigl, Karl
40
Reputation points
commented 2026-01-29T12:24:27.2133333+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,135
Reputation points Microsoft External Staff
Moderator
2 answers
SQL volume license not available
SQL server license was purchased through our reseller. Volume license is still not visible on my admin account
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-29T03:51:41.4333333+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, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lynda Lawrence
0
Reputation points
answered 2026-01-29T11:35: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(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
675
Reputation points Microsoft External Staff
Moderator
2 answers
Can SQL Server Developer Edition be used with real production data in Dev/Stage/PreProd?
Hi, I have two related questions about SQL Server Developer Edition licensing: Can we legally use Developer Edition in Stage or PreProd environments? Our production data (without masking/virtualization) is restored for developers in the development…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-21T15:34:41.5433333+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, 30%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFZ%3C/text%3E%3C/svg%3E)
Farid Zahin
0
Reputation points
commented 2026-01-29T10:30:34.5+00:00
Farid Zahin
0
Reputation points
2 answers
I have installed SSMS 2022 but unable to login.
Hello Team, I have installed SSMS 2022 on my local laptop. But I am unable to connect to the connection string. My laptop server name is ASHISH and instance name is MSSQLSERVER. I am entering ASHISH\MSSQLSERVER as Server Name but it is showing error code…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-19T09:20:08.8366667+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(102.4, 89%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ashish Karnavat
0
Reputation points
commented 2026-01-29T06:38:18.2966667+00:00
Lakshmi Narayana Garikapati
675
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server 2022 Express installation fails on Windows 11 using web installer
Hello, I’m trying to install SQL Server 2022 Express on a Windows 11 laptop, but the installation fails when using the web installer. Environment: Windows 11 (64-bit) Laptop (not a server) SQL Server 2022 Express (Web installer) SQL Server Management…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-28T01:26:17.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(291.2, 28.000000000000004%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
PEDRO DAVID RAMIREZ BECERRA
0
Reputation points
commented 2026-01-29T06:07:33.91+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
1 answer
Microsoft ACE.OLEDB.12.0 is not registered while import excel file
Microsoft ACE.OLEDB.12.0 is not registered -
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-27T08:59:23.8633333+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(92.8, 15%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENE%3C/text%3E%3C/svg%3E)
Noseda, Enzo
0
Reputation points
commented 2026-01-29T05:26:20.99+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
3 answers
Why does Optimized Locking (LAQ) rely on RCSI/tempdb row versions instead of ADR row versions?
I have a question regarding the new Optimized Locking feature (specifically the Lock After Qualification (LAQ) ) in SQL Server 2025. Database already has Accelerated Database Recovery (ADR) enabled, which maintains its own set of row versions as part of…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-24T04:55:01.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(204.8, 12%, 29%)' 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)
Steven Lam
20
Reputation points
commented 2026-01-29T04:58:26.42+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
2 answers
Running group MSA for agent service account won't let me back up to a NAS target
I'm running SQL Server 2022 in a clustered/AG environment, using a gMSA for the database engine and agent services. Even though I've granted full access to the NAS backup share, it cannot see it. We're using the Ola Hallengren maintenance solution. I've…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-23T20:34:15.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(262.40000000000003, 13%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DataMatt43
0
Reputation points
commented 2026-01-29T04:21:04.87+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
3 answers
I am having issues installing the SQL Server
I have been trying to install the SQL server for schoolwork. Every time I try the install process I get an error message stating (Wait on the Database Engine recovery handle failed). I have tried uninstalling and reinstalling the server and still no…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-21T13:44:24.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(224.00000000000003, 16%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
Winchell Sossous
0
Reputation points
commented 2026-01-29T03:58:42.64+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
2 answers
Databasemail stops working on SQL Server 2025 after CU1 install
We have server with SQL Server 2025 RTM that works fine but when we install CU1 for SQL Server 2025 the databasemail stops sending mail from SQL Server, nor error message no mail reach mailbox. SQL Server version 17.0.4005.7
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-20T18:20:29.8566667+00:00
Micael Carlsson
6
Reputation points
commented 2026-01-28T21:41:50.0466667+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, 87%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Park, Jay
0
Reputation points
1 answer
Cant create export of database
I cant create an export of one of our databases. ERROR: The ImportExport operation with Request Id '6001476a-69a8-46df-a766-70dc38edf723' failed due to 'One or more unsupported elements were found in the schema used as part of a data package. Error…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-22T12:37:59.93+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, 39%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gino
0
Reputation points
commented 2026-01-28T17:00:43.66+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, 2%, 11%)' 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)
Manoj Kumar Boyini
5,260
Reputation points Microsoft External Staff
Moderator
2 answers
Reinitializing the replication caused the deletion of database
I’m running a pull subscription using transactional replication between two databases, where the Publisher and Distributor are the same server. We removed the permissions for the account originally used for the replication job and replaced it with a new…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-21T10:29:15.6966667+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(54.400000000000006, 28.000000000000004%, 15%)' 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)
Shreyams Kumar
20
Reputation points
commented 2026-01-28T07:16:00.8866667+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
1 answer
I've installed SQL Server management studio 22, but I do not know how to set up or specify a server name
I'm not able to find the "snap-in" for SQL server on my PC
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-14T22:26:15.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(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Harvey Fram
0
Reputation points
commented 2026-01-27T13:52:23.8466667+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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
85
Reputation points Microsoft External Staff
Moderator
2 answers
Steps for Rolling AG Upgrade with new VM's (2016 OS & SQL)
I found the steps for a rolling upgrade of a 2 node AG in place, however I wish to also Upgrade o/s.. Are the steps any different if we add a new upgraded VM to the cluster & join it to AG, then Failover DB from Primary to this New server. Next add…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
asked 2026-01-23T00:02:31.8433333+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, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Brian Tobin
0
Reputation points
commented 2026-01-27T11:00:41.7766667+00:00
Lakshmi Narayana Garikapati
675
Reputation points Microsoft External Staff
Moderator