266 questions
0 answers
My PC stucking at server installation
Actually I downloaded the SQL server 2019 Express , but I tried to install it took 3-4 hors even it doens't completed
SQL Server Database Engine
asked 2025-06-20T12:24:32.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(12.8, 91%, 11%)' 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)
Saksi ENAGANDULA
0
Reputation points
commented 2025-06-20T12:40:27.66+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
Restore SQL 2022 database to a different server & change owners issue Error: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner
Hi, We copied/converted AS400 DB2 database to SQL 2022 database serverA and then backup & restore to SQL 2022 databaseB and when we try to change owners using a script (set @oldowner = 'CTL', set @newowner = 'TESTCTL') then it is throwing error. Msg…
SQL Server Database Engine
266 questions
asked 2025-06-20T03:33:45.0666667+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(60.8, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA6%3C/text%3E%3C/svg%3E)
AdnanMN-6863
0
Reputation points
answered 2025-06-20T09:30:36.5666667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
Is CVE-2025-29803 affecting SSMS 20.2.0 which comes with Visual Studio Tools for Applications 2019
I would like to check for "Security advisories 20.2.1", it states for "CVE-2025-29803" that "If you have already installed SSMS 20.2 or an earlier version installed on your machine, you are not exposed to this…
SQL Server Database Engine
266 questions
asked 2025-06-20T07:12:49.6633333+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPZ%3C/text%3E%3C/svg%3E)
Pei zhen Poon1
0
Reputation points
answered 2025-06-20T09:11:45.6166667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
Msg 241, Level 16, State 1, Procedure dbo.AttendanceRecords, Line 118 [Batch Start Line 2] Conversion failed when converting date and/or time from character string.
USE [AttendanceManagementSystem] GO /****** Object: StoredProcedure [dbo].[usp_GenerateAttendanceRecord] Script Date: 19-06-2025 09:50:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE…
SQL Server Database Engine
266 questions
asked 2025-06-19T04:22:56.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(236.8, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Manishankar T S
60
Reputation points
answered 2025-06-19T21:01:42.5733333+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
0 answers
Missing files on SQL Server install (SQLServerManager1x.msc, etc)
I had installed SQL Server Eval (v.15) and SQL Server Express (v.16) and the SQL Server Configuration Manager appears to be missing. I have looked for SQLServerManager1x.msc (and all versions from 15 to 20) and I can't find it. looking in…
SQL Server Database Engine
266 questions
asked 2025-06-19T13:33:45.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(278.4, 15%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Terry McPharlin
0
Reputation points
commented 2025-06-19T20:55:04.9866667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
In Visual Studio 2022, SSDT, SQL Project External Tables - Build Error!
Title: External Table Build Error in SSDT – SQL46010 near ')' but works in SSMS Hi, I’m working with Visual Studio 2022, SSDT, and SQL Server Projects, and I’m trying to create external tables in an Azure SQL Database. The external table creation works…
SQL Server Database Engine
266 questions
asked 2025-06-18T17:25:26.11+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(131.20000000000002, 70%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Seven Hills
0
Reputation points
answered 2025-06-19T06:49:41.06+00:00
Olaf Helper
47,441
Reputation points
0 answers
Can't enlist target server for SQL Server Agent
TITLE: Microsoft.SqlServer.Smo MSX enlist failed for JobServer 'iris-wl-a301.tw01.ppanggu.com'. For help, click:…
SQL Server Database Engine
266 questions
asked 2025-06-19T03:39:02.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(134.4, 42%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ5%3C/text%3E%3C/svg%3E)
Jessica - 568Win
0
Reputation points
asked 2025-06-19T03:39:02.9066667+00:00
Jessica - 568Win
0
Reputation points
3 answers
How to install SQL Server Developer on a Snapdragon Laptop
I got a new Dell laptop that has a Snapdragon processor and am unable to install SQL Server. Is there a procedure for doing this? If the solution is emulation, then is there a procedure for setting up emulation too? Thanks
SQL Server Database Engine
266 questions
asked 2025-06-17T21:19:04.1466667+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(166.4, 33%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Robert Watson
0
Reputation points
edited an answer 2025-06-18T22:20:05.12+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)
78,006
Reputation points
Volunteer Moderator
1 answer
asked 2025-06-18T16:50:02.1933333+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(38.4, 42%, 13%)' 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)
Bryant, Kiana (NBT)
0
Reputation points
answered 2025-06-18T20:38:35.6066667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
0 answers
How to delete SQL server in Registry or Cache
So, for almost 2 days I am breaking my head why these entries are not been deleted despite I did it multiple times. Could someone help me out and fix this real quick? PS C:\WINDOWS\system32> Get-WmiObject -Class Win32_Product | Where-Object {…
SQL Server Database Engine
266 questions
asked 2025-06-17T19:35:14.24+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, 46%, 33%)' 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)
Nithish Kumar
0
Reputation points
commented 2025-06-18T06:24:45.1733333+00:00
Nithish Kumar
0
Reputation points
1 answer
Transaction log backup fails randomly in SQL Server 2019
Running SQL Server 2019 on Windows Server 2022, with full backups scheduled every Sunday night, incremental backups nightly, and archive logs every 15 minutes. Several times a day, the transaction log backup fails with the following error during one…
SQL Server Database Engine
266 questions
asked 2025-06-16T16:11:25.0833333+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, 87%, 13%)' 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)
Lee Davis
0
Reputation points
answered 2025-06-16T21:28:29.7033333+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
How to give a user SQL permission to execute stored procedure using powershell invoke-sqlcmd
Hi All, Hope someone has a solution for me. I have a MS SQL 2016 server. I have created a stored procedure and set execute as to Owner. I would like to have standard user be able to run this stored procedure using the PowerShell command invoke-sqlcmd.…
SQL Server Database Engine
266 questions
asked 2025-06-05T22:39:26.3333333+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, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Craig Garland
336
Reputation points
commented 2025-06-15T22:52:41.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(204.8, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Craig Garland
1
Reputation point
1 answer
Increased CPU usages during SQL manged instance Maintenance
One of our SQL Managed Instances experienced a CPU usage increase from 40% to 90%, despite a constant user workload. We noticed that SQL was restarted around time, and Azure has confirmed ongoing maintenance through notification. However, the maintenance…
SQL Server Database Engine
266 questions
asked 2025-06-14T06:54:02.4666667+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(73.60000000000001, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joby Mathew
5
Reputation points
commented 2025-06-14T19:21:47.9+00:00
Joby Mathew
5
Reputation points
1 answer
Performance issue while reorganizing an index on a very large table
Hello Team, We're encountering a performance issue while reorganizing an index on a very large table (1.4TB with 1.5 billion records) in one of managed instance in other tenant. Since index reorganization is an online activity less impact our user…
SQL Server Database Engine
266 questions
asked 2025-06-10T14:10:34.1266667+00:00
Joby Mathew
5
Reputation points
commented 2025-06-14T06:57:41.9066667+00:00
Joby Mathew
5
Reputation points
1 answer
SQL Server Enterprise Edition (Server + CAL) + Software Assurance – Licensing Compliance with More Than 20 Cores
I would like to confirm if my current SQL Server configuration is compliant with Microsoft licensing rules. Here are the key points: · We have a Microsoft SQL Server Enterprise Edition license. · Our company has always Software Assurance. · …
SQL Server Database Engine
266 questions
asked 2025-06-13T12:31:45.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(118.4, 93%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jaroslaw Pelc
0
Reputation points
answered 2025-06-13T20:14:38.0133333+00:00
Bruce (SqlWork.com)
78,006
Reputation points
Volunteer Moderator
0 answers
SQL Server Always On – Intermittent Cluster Failures in Test Setup
I am reaching out to receive support for SQL Server Always On configurations, specifically involving multi-node clusters with geographically distributed replicas in a test environment. I am currently evaluating the integration of an asynchronous…
SQL Server Database Engine
266 questions
asked 2025-06-13T14:17:10.49+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, 57.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Matthew Tanner
0
Reputation points
asked 2025-06-13T14:17:10.49+00:00
Matthew Tanner
0
Reputation points
1 answer
Configure Resource Governor for SQL Jobs with SQL Login
How can a CheckDB job be configured to use Resource Governor to assign work to the checkDBworkpool for a SQL Login (specifically mylogin)? The challenge arises from the inability to create a proxy for SQL Logins when setting up the SQL job step, which…
SQL Server Database Engine
266 questions
asked 2025-06-11T12:42:49.72+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(300.8, 20%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Praneeth Eranti
210
Reputation points
edited a comment 2025-06-12T16:58:50.35+00:00
Sai Praneeth Eranti
210
Reputation points
0 answers
Unable to install sql server 2022 in Windows 11
Unable to install SQL server 2022 screen got stuck so please help me. I have attached screenshot for your reference.
SQL Server Database Engine
266 questions
asked 2025-06-12T06:19:59.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(67.2, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ramchandra Bhuse
0
Reputation points
commented 2025-06-12T15:40:08.52+00:00
Balmukund
176
Reputation points Microsoft Employee
1 answer
Error installing SQL Express
I am trying to install SQL server Express 2022. I have tried a few times including using https://www.sql-easy.com/learn/how-to-uninstall-sql-server/ and https://vladdba.com/2025/01/22/repair-a-sql-server-instance/ to uninstall and repair the install. I…
SQL Server Database Engine
266 questions
asked 2025-06-11T16:39:00.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(179.20000000000002, 82%, 27%)' 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)
JB
0
Reputation points
answered 2025-06-11T21:33:29.53+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
Understanding SMTP Authentication in SQL Database Mail Configuration
In the SQL Database Mail Configuration Wizard, basic authentication is currently being used. Does this imply the use of interactive or non-interactive login? Some articles suggest that providing a username and password constitutes interactive login,…
SQL Server Database Engine
266 questions
asked 2025-05-06T08:24:08.3066667+00:00
Sai Praneeth Eranti
210
Reputation points
commented 2025-06-11T12:31:00.26+00:00
Sai Praneeth Eranti
210
Reputation points