SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,026 questions
3 answers
How to ensure SQL Cluster is running properly after failover
How to ensure SQL Cluster is running properly after failover?
asked 2024-06-08T00:45:09.9433333+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(57.599999999999994, 53%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWY%3C/text%3E%3C/svg%3E)
WANG Yuzhi
20
Reputation points
answered 2024-06-11T08:42:42.85+00:00
MikeyQiaoMSFT-0444
1,085
Reputation points
2 answers
Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11
Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…
asked 2024-06-10T20:42:40.8233333+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, 60%, 39%)' 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)
Majid KH
0
Reputation points
commented 2024-06-11T08:25:21.9633333+00:00
Olaf Helper
42,361
Reputation points
1 answer
Get Global Primary details from All the replicas in Distributed AlwaysOn
In Distributed AlwaysOn, I could not find any DMVs in SQL Server which could provide the details about Global Primary from replicas in Forwarder side (both Primary Forwarder and its local replicas). Is there a way to at-least pull the Global Primary…
asked 2024-06-10T14:06:34.08+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, 22%, 39%)' 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)
Sajal Bagchi
0
Reputation points
edited an answer 2024-06-11T07:53:36.82+00:00
LucyChenMSFT-4874
2,010
Reputation points
2 answers
How to fix Component error code: 0x80004005 Error description: Unknown error (0xe0000235) during the SQLEXPRADV_x64_PTB (2017) installation?
Hello! I'm having some issues with the SQLEXPRADV_x64_PTB installation (2017 version). I use an MAC MacBook Air Apple M2 (masOS Sonoma 14.1) and Parallels ARM Virtual Machine to run Windows 11 Home 64 bits. In summary, the problem is as follows: Detailed…
asked 2024-06-07T12:07:27.27+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(137.6, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP5%3C/text%3E%3C/svg%3E)
PauloMoreira-5852
0
Reputation points
answered 2024-06-11T07:02:13.5366667+00:00
MikeyQiaoMSFT-0444
1,085
Reputation points
2 answers
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is…
asked 2024-06-09T22:09:54.9333333+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Eghost
0
Reputation points
edited an answer 2024-06-11T06:01:32.1466667+00:00
LucyChenMSFT-4874
2,010
Reputation points
0 answers
Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when __$operation = 1 or __$operation = 3. how to resolve this.
Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column…
asked 2024-06-11T05:26:26.9866667+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, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUK%3C/text%3E%3C/svg%3E)
UDAY KIRAN
0
Reputation points
commented 2024-06-11T05:46:05.5066667+00:00
Olaf Helper
42,361
Reputation points
1 answer
SQL Server Import and Export Wizard is showing error while importing files
I am trying to import an excel file into SQL Server Management Studio and this error comes up: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value…
asked 2024-06-10T18:28:21.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(105.60000000000001, 5%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deborah Dollesin
0
Reputation points
answered 2024-06-11T05:39:58.6733333+00:00
ZoeHui-MSFT
34,351
Reputation points
3 answers
SQL login issue
I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?
asked 2024-06-10T10:03:55.5233333+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(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gurpreet Khaira
0
Reputation points
answered 2024-06-11T05:35:58.9033333+00:00
ZoeHui-MSFT
34,351
Reputation points
3 answers
MSSQL Server 2019 std edition EOS date
When is the end of support (EOS) date for Microsoft SQL Server 2019 Standard Edition?
asked 2024-06-07T11:16:05.56+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, 93%, 15%)' 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)
Sariethv
0
Reputation points
answered 2024-06-11T05:20:49.1233333+00:00
Olaf Helper
42,361
Reputation points
2 answers
SQL 2012 error
Does anyone know how to solve this error? TITLE: Microsoft SQL Server 2012 Setup The following error has occurred: Locating the SQL Server Browser service component failed with Windows Installer return code '2'.
asked 2024-06-08T19:38:49.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(144, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
ramon corvo
0
Reputation points
answered 2024-06-11T05:20:17.8466667+00:00
ZoeHui-MSFT
34,351
Reputation points
0 answers
Unexpected truncation error when inserting from UTF8 to non-UTF8 collation
I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…
![](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(9.6, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
NTWDBLIB.DLL is not loadable
When I run the SQL Server Client Network Utility, the DB-Library Options show the ntwdblib.dll as not loadable.And the service is legacy which has to use the same ntwdblib.dll and can't afford to use latest/different sql library. Does anyone know why the…
asked 2024-06-06T12:19:16.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(188.79999999999998, 94%, 28%)' 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)
Gnanasoundari
20
Reputation points
accepted 2024-06-11T04:34:34.67+00:00
Gnanasoundari
20
Reputation points
2 answers
WHY Index Scan Instead Of Seek While Joining Big Table With #Temp Table
In my sql server 2016 database, I have a table 'BigData' having around 50 million rows and a Temporary table #TempID which contains 600 rows. CREATE TABLE BigData (ID INT IDENTITY(1,1) PRIMARY KEY, OtherID INT, Comment nvarchar(max),…
asked 2024-06-10T11:46:44.9033333+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, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vikrant Sirohi
0
Reputation points
edited a comment 2024-06-11T03:45:37.8833333+00:00
Vikrant Sirohi
0
Reputation points
2 answers
Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?
I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …
asked 2024-06-08T19:29:32.7133333+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(28.799999999999997, 62%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vinith
0
Reputation points
edited an answer 2024-06-11T03:36:35.1+00:00
LucyChenMSFT-4874
2,010
Reputation points
2 answers
blocking due to cuncurrency problem.
hi, I have a table "bridge" where i keep bridgeid as pk , and hardly four to 5 rows are there CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL CONSTRAINT [PK_bridge] PRIMARY KEY CLUSTERED ( [bridgeid]…
asked 2024-06-10T06:08:53.8766667+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, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-06-11T03:19:26.7666667+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
1 answer
Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?
I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …
asked 2024-06-08T20:03:42.3633333+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, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Vinith Ankam
0
Reputation points
answered 2024-06-11T03:08:25.7433333+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
1 answer
Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'
Some EF Core queries are throwing the following error in our code : Cannot continue the execution because the session is in the kill state. Une erreur grave s'est produite pendant la commande actuelle. Les résultats devront être supprimés, le cas…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
710 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,026 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,456 questions
asked 2024-06-07T10:02: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(195.2, 26%, 28%)' 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)
Arthur Menétrey
0
Reputation points
commented 2024-06-11T02:55:34.25+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
2 answers
I am unable to install SQL server on my window 11, the error is unable to install SQL server(setup.exe) exit code (Decimal): -2061893606
2024-06-08 14:07:53.35 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: ) (Hypervisor) 2024-06-08…
asked 2024-06-08T18:50:36.4033333+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, 6%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Moges Hailu
0
Reputation points
answered 2024-06-11T02:49:34.38+00:00
ZoeHui-MSFT
34,351
Reputation points
2 answers
transpose row data into columns
Hope I'm asking this correctly. I have a table in this format: I need to have the Unique ID and the account numbers from both stores all in the same record. Like this: How can I accomplish this in SQL? Is this some kind of PIVOT or UNPIVOT? What…
asked 2024-06-08T14:01:19.5733333+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, 23%, 36%)' 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)
Dom
751
Reputation points
answered 2024-06-11T02:41:48.63+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
2 answers
sql server installation issue exit code 2147467259
Summary.txt this is the summary file from the log, pls help me with my issue
asked 2024-06-07T18:15:59.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(214.4, 95%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Ahmed Nazeer
0
Reputation points
answered 2024-06-11T02:36:27.0166667+00:00
ZoeHui-MSFT
34,351
Reputation points