256 questions
0 answers
Migration of Data
Hello, What is is the best and most efficient (performance wise) method to migrate of full data from large database to small multiple database (microservices) during cutover. Thanks
SQL Server Database Engine
asked 2025-06-26T13:22:39.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(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SVA
116
Reputation points
commented 2025-06-29T21:07:06.18+00:00
Erland Sommarskog
121.4K
Reputation points MVP
Volunteer Moderator
2 answers
I can't download SSMS, It provide Visual Studio in SSMS's Link
Dear, I can not download SQL Server Management Studio, while i click to Download SSMS it automatically download Visual Studio. Why this happed, i got this problem for a long time. This is the link…
SQL Server Database Engine
256 questions
asked 2025-06-29T07:51:38.34+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, 88%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sowrov
0
Reputation points
answered 2025-06-29T09:19:22.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(150.4, 57.99999999999999%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Berneice Heaney
0
Reputation points
1 answer
CU18 patch failed on my sql server 2022. SQL server is not restarting (Database engine patch failed)
How to fix this error, i got this error after applying cu18 patch to sql 2022, the error only cites that sql server agent coulnt start as sql server is down, the event viewer error code is 7001
SQL Server Database Engine
256 questions
asked 2025-06-27T01:39:30.5866667+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, 46%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Peter Muhumuza
0
Reputation points
answered 2025-06-27T21:19:06.5233333+00:00
Erland Sommarskog
121.4K
Reputation points MVP
Volunteer Moderator
1 answer
microsoft sql server 2022 installation error
The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start. even i followed all steps…
SQL Server Database Engine
256 questions
asked 2025-06-25T08:53:41.03+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(281.6, 14.000000000000002%, 37%)' 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)
BHARGAV G
0
Reputation points
answered 2025-06-25T20:56:42.47+00:00
Erland Sommarskog
121.4K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Where is the Microsoft SQL Server 2022 Express License Terms for Redistribution and Hosting?
Where is the Microsoft SQL Server 2022 Express License Terms for Redistribution and Hosting? For SQL Server 2005 Express through SQL Server 2014 Express, the page is here: https://www.microsoft.com/en-sg/download/details.aspx?id=29693 However, that page…
SQL Server Database Engine
256 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(86.4, 26%, 18%)' 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)
1 answer
COBOL V9 - SQL server query processing is reporting error | Need Help
Hello Experts, Greetings to All ! In our environment, there exist a COBOL V9 version POD which connects to SQL server (2019) using ODBC driver V18. In this client-server design, during the query retrieval process from COBOL to SQL server , we are getting…
SQL Server Database Engine
256 questions
asked 2025-06-24T09:29:45.16+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, 94%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Naren
25
Reputation points
commented 2025-06-24T20:57:26.3666667+00:00
Erland Sommarskog
121.4K
Reputation points MVP
Volunteer Moderator
3 answers
Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?
Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…
SQL Server Database Engine
256 questions
asked 2025-06-12T12:44:51.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(249.60000000000002, 57.99999999999999%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Sebastien Flaesch
31
Reputation points
commented 2025-06-24T15:11:35.57+00:00
Sebastien Flaesch
31
Reputation points
3 answers
How many logical cores supported by SQL Server 2022 Standard Edition without purchasing more cores?
I am looking at purchasing Microsoft SQL Server 2022 Standard Edition to run on premise. When researching the editions online I can see that there is a maximum core count of 24 logical cores per instance. And then when I look at the pricing page…
SQL Server Database Engine
256 questions
asked 2025-06-20T18:19:20.2633333+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, 49%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Brian Athans
0
Reputation points
commented 2025-06-23T02:39:59.59+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)
77,686
Reputation points
Volunteer Moderator
1 answer
Best method to upgrade SQL to new version and remove older versions
We have several Windows servers that have multiple versions of SQL Server installed. A few servers are running SQL Server 2012, 2014 and 2016 (at least there are components from each build). IinfoSec would like the old versions removed for auditing…
SQL Server Database Engine
256 questions
asked 2025-06-20T20:24:01.47+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, 41%, 20%)' 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)
Daniel Andryszak
121
Reputation points
commented 2025-06-22T10:49:20.2466667+00:00
Lakshya Kurup
10
Reputation points
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
256 questions
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.4K
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
256 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.4K
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
256 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.4K
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
256 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.4K
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
256 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.4K
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
256 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,436
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
256 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
256 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
Bruce (SqlWork.com)
77,686
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.4K
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
256 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
256 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.4K
Reputation points MVP
Volunteer Moderator