SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,286 questions
0 answers
Capture DML
Hi How can I capture DML operations of a table without impacting the performance. Lightweight process to capture all transactions. Thanks
![](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)
1 answer
How to fix the unique string constraint column value identified or differed with space and can be inserted
We have database which column of type varchar has unique constraint and two values needs to be inserted string differed by spaces "VAT-01" & "VAT-01 "
asked 2025-01-14T07:59:46.0166667+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, 68%, 35%)' 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)
Badhe, Ganesh
60
Reputation points
edited a comment 2025-01-14T11:07:46.2066667+00:00
Viorel
118.9K
Reputation points
5 answers
One of the answers was accepted by the question author.
SSIS Toolbox Missing
I do not have the SSIS toolbox option on my SSMS program. I followed these direcetions: https://zcusa.951200.xyz/en-us/sql/integration-services/ssis-toolbox?view=sql-server-ver16 and I still don't see the tool box.
asked 2022-09-14T15:05:55.91+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, 3%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWH%3C/text%3E%3C/svg%3E)
William Hull
21
Reputation points
commented 2025-01-14T09:50:31.9666667+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, 85%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Suliman Benhalim
0
Reputation points
5 answers
One of the answers was accepted by the question author.
SSIS Toolbox Missing
I do not have the SSIS toolbox option on my SSMS program. I followed these direcetions: https://zcusa.951200.xyz/en-us/sql/integration-services/ssis-toolbox?view=sql-server-ver16 and I still don't see the tool box.
asked 2022-09-14T15:05:55.91+00:00
William Hull
21
Reputation points
commented 2025-01-14T09:50:31.9666667+00:00
Suliman Benhalim
0
Reputation points
1 answer
Connection string failure with SQL Server ODBC connection
Hi, ALL, I have weird problem as follows: In my program I use SQLDriverConnect() to connect to the SQL Server. Before this call I modify the connection string in order to use MARS. I set up DSN and if everything is good, meaning I run the program and I…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,286 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,822 questions
asked 2025-01-13T17:25:54.02+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(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Igor Korot
26
Reputation points
answered 2025-01-14T08:29:42.57+00:00
LiHongMSFT-4306
29,826
Reputation points
1 answer
One of the answers was accepted by the question author.
Backup SQL Failed
Hello Everyone! When i backup SQL, i saw this issue, please help me to fix it Message Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights…
asked 2025-01-14T07:24:30.89+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(169.60000000000002, 63%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hai, Do Duc
0
Reputation points
accepted 2025-01-14T07:42:02.4133333+00:00
Hai, Do Duc
0
Reputation points
2 answers
I can't set up a connection to the database when installing VMM
Hello! When installing VMM on the first host, I cannot connect to the database if I specify the MS SQL cluster name. As indicated in paragraph number 8 of this…
asked 2025-01-13T11:52:52.1733333+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(51.2, 32%, 14%)' 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)
Maxtor007
20
Reputation points
answered 2025-01-14T06:57:36.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(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
XinGuo-MSFT
20,396
Reputation points
1 answer
SSRS2022 Custom Header Problem
Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…
asked 2025-01-07T02:59:18.05+00:00
Wilson Shen
0
Reputation points
commented 2025-01-14T06:16:47.55+00:00
Wilson Shen
0
Reputation points
1 answer
Measure grand total
Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock,…
asked 2025-01-13T20:35:23.1966667+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, 8%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPQ%3C/text%3E%3C/svg%3E)
Pedro Quiroz
0
Reputation points
commented 2025-01-14T05:36:13.6366667+00:00
ZoeHui-MSFT
39,496
Reputation points
2 answers
Query on cluster
Hi All, I have a Failover Cluster Manager setup with two nodes (let's say Server01 and Server02), both running Windows Server 2019. Both nodes are part of an Always On Availability SQL cluster. I want to remove Server02 from the Failover Cluster…
asked 2025-01-12T07:22:59.39+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, 7.000000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Glenn Maxwell
12,001
Reputation points
answered 2025-01-14T03:41:08.1366667+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(128, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue
38,851
Reputation points Microsoft Vendor
0 answers
BLOB ERROR
When I run the refresh one of my tables is not mirroring its counterpart in the production database. The comment is BLOB error. What is a BLOB error. the dependent tables are fine but the parent table won't generate data.
asked 2025-01-13T16:15:49.25+00:00
D.Z. McClintock
0
Reputation points
commented 2025-01-14T03:06:27.4066667+00:00
LiHongMSFT-4306
29,826
Reputation points
1 answer
SQL Express Installation Issues on Windows 11 Enterprise v10.0.22631
Experiencing installation failures with SQL Express 2022 on Windows 11 Enterprise. The installation appears to work until nearly the end, where it encounters issues related to x_cpu64 type files. The installation completes but reports a failure with a…
asked 2025-01-13T15:24:52.2533333+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, 65%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Laidlaw, Jason [EMR/MSOL/ABDN]
0
Reputation points
answered 2025-01-14T02:53:29.5066667+00:00
LiHongMSFT-4306
29,826
Reputation points
1 answer
How do you ask MS to update the SSIS Exe package that has an expired Certificate?
The Current version of SSIS 4.6 comes digitally signed with a certificate that expired in Nov 2024. Does anyone know the correct way to get this information to someone who can do something about it?
asked 2025-01-14T01:34:15.8666667+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(310.4, 53%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gavin Peters
0
Reputation points
answered 2025-01-14T02:39:38.34+00:00
ZoeHui-MSFT
39,496
Reputation points
3 answers
Usage of SQL Server Schema Compare v1.21.0 extention
Hello, I am using ADS: Version: 1.50.0 (system setup) Commit: 49c73a84388731fec941dac8d938345ac16bd470 Date: 2024-11-17T22:41:05.327Z VS Code: 1.82.0 Electron: 30.5.1 Chromium: 124.0.6367.243 Node.js: 20.16.0 V8: 12.4.254.20-electron.0 OS: Windows_NT x64…
asked 2025-01-10T20:25:30.6466667+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, 10%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
Voldman, Eliya
0
Reputation points
commented 2025-01-13T21:57:51.2633333+00:00
Erland Sommarskog
115.3K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Can the MSSQL JDBC driver connect to a SQL SERVER using a GMSA account?
Is it possible for the MSSQL JDBC driver to connect to a SQL SERVER using a GMSA account? If it is, what should the connection string look like? Can the connection URL include the GMSA account name, such as…
asked 2023-10-20T09:20:34.7466667+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, 98%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chiru
25
Reputation points
commented 2025-01-13T21:51:37.3266667+00:00
Erland Sommarskog
115.3K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
An invalid tabular data stream (TDS) collation was encountered (Not linked Server)
We just upgraded one of our sites for SQL Server 2019 and since then our software cannot write to any of the blob fields in the database. We get the following error: "An invalid tabular data stream (TDS) collation was encountered." We…
asked 2021-03-03T22:36:28.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(41.6, 66%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Christopher Burke
96
Reputation points
commented 2025-01-13T19:29:08.99+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, 80%, 30%)' 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)
Jérémy Belloir
0
Reputation points
1 answer
MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "
Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…
asked 2024-12-26T16:44:24.62+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, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Fred Bartley
0
Reputation points
answered 2025-01-13T18:10:51.1733333+00:00
Fred Bartley
0
Reputation points
1 answer
MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "
Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to…
asked 2024-12-26T16:44:24.62+00:00
Fred Bartley
0
Reputation points
answered 2025-01-13T18:10:51.1733333+00:00
Fred Bartley
0
Reputation points
1 answer
Timeline for Release of NEXT GEN Feature for Managed Service in Azure
What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?
asked 2025-01-07T15:40:00.9233333+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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-01-13T16:42:23.0033333+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(252.8, 60%, 34%)' 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)
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Upgrading SQL server 2019 enterprise evaluation edition to SQL Server 2022 Standard
HI All, I am planning to Upgrading SQL server 2019 enterprise evaluation edition to SQL Server 2022 Standard. when I run SQL server 2022 standard installation setup upgrade edition step it is missing select instance name step and there is no option to…
![](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, 94%, 31%)' 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)