SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 questions
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
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
commented 2026-01-30T08:02:05.4033333+00:00
Patrick LEONARD
0
Reputation points
4 answers
One of the answers was accepted by the question author.
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
accepted 2026-01-30T02:27:12.75+00:00
Steven Lam
20
Reputation points
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
609 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(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
How to install my SQL Server Express 2025
Hi, I have issues regarding the SQL Server 2025 Express and I got this error/trouble-shooting message popped up this display. Can you help me process this step by step how to resolve this? I'm using Windows 11 (I think) in this case. Thank you.
SQL Server | Other
14,649 questions
asked 2026-01-29T05:19:45.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(16, 36%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michael Le
0
Reputation points
commented 2026-01-29T22:31:38.2633333+00:00
Erland Sommarskog
131.7K
Reputation points MVP
Volunteer Moderator
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
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
Install SQL Management Studio without Visual Studio Tools or Shell
Hi there, I am doing some pen test remediation and our SQL servers are flagging that Visual Studio tools such as Shell (isolated) and Tools for applications are vulnerable. So i've been trying to find a way to install SSMS without Visual Studio at all as…
Windows for business | Windows Server | User experience | Other
20,351 questions
SQL Server | Other
14,649 questions
asked 2023-11-24T14:04:03.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(99.2, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TheLoops
6
Reputation points
commented 2026-01-29T21:57:27.28+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
1 answer
SQL error -An expression of non-boolean type specified in a context where a condition is expected
Thanks in advance for any help folks can offer. I've been pulling my hair our all day yesterday trying to figure out how to fix this. I received the error below after I added 3 new lines (line 60, 61 and 62). The original code without these 3 new lines…
SQL Server | SQL Server Transact-SQL
262 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(112.00000000000001, 26%, 20%)' 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)
![](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(176, 21%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
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
1 answer
ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering
We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…
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,136 questions
asked 2025-07-08T12:42:00.13+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(67.2, 90%, 16%)' 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)
MrG
0
Reputation points
answered 2026-01-29T12:19:49.9066667+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
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
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 forgot my password i set for microsoft sql and even name . so can i make new id again
Forgot my Password And and entry name With which I logined so can I reset Or how can I make New ID If I don't know anything about the old account..
SQL Server | Other
14,649 questions
asked 2026-01-02T09:36:33.4733333+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(25.6, 36%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
ROOPREET GUPTA
0
Reputation points
commented 2026-01-29T09:57:03.81+00:00
Akhil Gajavelly
1,135
Reputation points Microsoft External Staff
Moderator
1 answer
Birthday attacks against Transport Layer Security (TLS) ciphers with 64bit block size Vulnerability (Sweet32)
Hi Recently deployed in server this vulnerabilities. Since then the email delivery in SSRS is not working. Can someone help with this issue? This is the error message.
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,136 questions
asked 2026-01-28T10:58:37.1866667+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, 73%, 20%)' 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)
Ann Marion Fernandez
0
Reputation points
answered 2026-01-29T09:05:47.9966667+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(284.8, 66%, 37%)' 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)
Shruti Dhruv
800
Reputation points Microsoft External Staff
Moderator
0 answers
NHS worker; using 'Waiting PTL' option via SQL
I am working by using data on the Admitted PTL (NHS). I am trying to book patients' appointments using filtered down data, by who hasn't had a pre assessment prior to surgery. The option 'Had Pre-Assessment?' is not working. I'm getting the same figures…
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,136 questions
asked 2026-01-21T13:34:44.05+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, 41%, 23%)' 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)
JADE D
0
Reputation points
commented 2026-01-29T06:42:24.72+00:00
Lakshmi Narayana Garikapati
675
Reputation points Microsoft External Staff
Moderator
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
2 answers
One of the answers was accepted by the question author.
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 | SQL Server Transact-SQL
262 questions
asked 2026-01-26T11:52:11.7366667+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
accepted 2026-01-29T06:16:07.97+00:00
Shreyams Kumar
20
Reputation points
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