739 questions with SQL Server-related tags

Sort by: Updated
0 answers

Does windows support virtio_vsocket as host?

Does windows and hyper-v support virtio_tansport( virtio_vsocket) as host? if support, what are the advantages of hyperv_transport(hyperv_socket) over virtio_tansport(virtio_vsocket)? what is the reason why we are developing a new vsocket…

Azure VMware Solution
Azure VMware Solution
An Azure service that runs native VMware workloads on Azure.
319 questions
System Center Virtual Machine Manager
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,551 questions
Windows 10 Network
Windows 10 Network
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Network: A group of devices that communicate either wirelessly or via a physical connection.
2,275 questions
asked 2024-05-08T08:58:15.1933333+00:00
emma 0 Reputation points
0 answers

how to set order by ND columns

Hello This is my sql code DECLARE @cols NVARCHAR(MAX)='' DECLARE @query NVARCHAR(MAX)='' DECLARE @COLS_SUM NVARCHAR(MAX)='' DECLARE @COLS_TOT NVARCHAR(MAX)='' --Preparing columns for Pivot SELECT @cols = @cols + isnull(QUOTENAME(ND),0) +…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-05-08T08:16:54.46+00:00
RAVI 916 Reputation points
edited the question 2024-05-08T08:23:51.1533333+00:00
RAVI 916 Reputation points
0 answers

User Managed identity with failover group with servers in different regions

while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-05-07T19:44:02.75+00:00
KAMALPREET KAUR 1 Reputation point Microsoft Employee
commented 2024-05-08T00:45:15.15+00:00
GeethaThatipatri-MSFT 27,717 Reputation points Microsoft Employee
0 answers

Ununable to install sql server (setup.exe) Exit code (Decimal): -2147467259 Error description: The service did not respond to the start or control request in a timely fashion.

I'm trying to download SQL express through the installation process it gives me an error Oops... Unable to install sql server (setup.exe) Exit code (Decimal) -2147467259E Error description: The service did not respond to the start or control request in…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-30T15:39:20.9433333+00:00
moris shehady 0 Reputation points
commented 2024-05-07T21:15:27.4233333+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

The target principal name is incorrect

Hi Team, I've got the error "The target principal name is incorrect. Cannot generate SSPI context" when I tried to connect to SQL Server from other server. I've checked sql logs and I found info SPN was registered . I've run Kerberos…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-05-06T13:06:14.6233333+00:00
Marcin Woszczyna 0 Reputation points
commented 2024-05-07T09:39:12.2266667+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
0 answers

Key store providers cannot be set more than once(Always Encrypted with JDBC and Java 8)

We are trying to use SQL Always Encrypted feature in our Java Web Application. Java 8 is the JRE and uses mssql-jdbc-9.2.1.jre8.jar as the jdbc driver. Azure-Key-vault as the column master key store provider Our application uses below code to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2021-11-09T04:53:17.773+00:00
Subin Sankaran 1 Reputation point
commented 2024-05-07T09:07:01.79+00:00
0 answers

SetDatabaseConnection WMIMethodException Error

I'm using a slightly modified version of the script found here: https://blog.aelterman.com/2018/01/03/complete-automated-configuration-of-sql-server-2017-reporting-services/. The modification is that I'm pointing to (local)\SQLExpress on line 41 as the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,091 questions
asked 2024-05-06T19:26:46.2033333+00:00
Mike Horton 0 Reputation points
edited the question 2024-05-07T02:31:33.8733333+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
0 answers

Error creating SQL user accounts from external provider with Azure Arc

When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
328 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.
12,777 questions
asked 2024-05-03T12:16:54.9066667+00:00
AJ Copeland 0 Reputation points
commented 2024-05-03T21:36:15.92+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

How do I transfer an on-premises license from one corporate user to another?

I need to transfer an on-premise license, but I'm having trouble finding materials explaining the step-by-step process, as well as which instrument should be used for the transfer. Can You help me?

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,777 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.
12,777 questions
asked 2024-05-03T12:29:56.53+00:00
Takeo Contao Abe TERNIUM BR 0 Reputation points
commented 2024-05-03T21:35:32.0933333+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

tại sao khi kết nối với máy chủ SQL 2022 Azure lại không có Restore Database

Khi tôi cài đặt Azure Data Studio kết nối với SQL bản 2022 và muốn restore advanturework 2022 để thực hành thì không có mục Restore dữ liệu khi nhấn chuột phải vào Database mà chỉ có mục Filter và Refesh. Làm thế nào để sửa lỗi này?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
asked 2024-05-02T10:05:53.28+00:00
Ngọc Yến Đặng 0 Reputation points
commented 2024-05-02T21:07:25.5733333+00:00
Erland Sommarskog 101.4K Reputation points MVP
0 answers

SSDT DEployment fails with "The Element or Annotation class SqlIndex does not contain the Property class Online"

Trying to deploy our DBs SSDT, both in an Azure Pipeline and on our team's Docker, fails with the following error: Assembly Initialization method <MyAssembly>.ComponentTestBase.AssemblyInit threw exception.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-05-01T13:00:59.15+00:00
Ron Anoshi 10 Reputation points
edited the question 2024-05-02T01:23:15.2066667+00:00
Anna Xiu-MSFT 25,806 Reputation points Microsoft Vendor
0 answers

How do I upgrade SQL server from 2016 to 2019

The current version is showing as SQL server 13.0.5893.48 after I thought I had upgraded it to 2019.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-29T12:54:12.8533333+00:00
Billy Barber 0 Reputation points
commented 2024-04-29T17:56:55.8166667+00:00
Billy Barber 0 Reputation points
0 answers

SQL Server Integration Services Projects 2022 exe for VS2022 is not detecting VS2022 and hence unable to install it

When i install SQL Server Integration Services Projects 2022, it does not detect my installed VS 2022. Hence, unable to select any VS and install. I tried from different machines.. in some machines its getting detected, but disabled, doesn't allow me to…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
asked 2024-04-29T10:52:06.8966667+00:00
SAILANATHAN Balaji 20 Reputation points
0 answers

Security update for SQL Server 2022 CU12 - patch update failed

Security update for SQL Server 2022 CU12 Patch installation failed. Product: SQL Server 2022 Database Engine Shared - Update 'Hotfix 4120 for SQL Server Database Services Core Shared (64-bit) (KB5036343)' could not be installed. Error code 1603. Action…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-28T17:43:10.8433333+00:00
Santhosh, Vuppala 0 Reputation points
commented 2024-04-29T01:34:55.1366667+00:00
LucyChen-MSFT 1,120 Reputation points Microsoft Vendor
0 answers

How to find midpoint of a polyline

How would you calculate the x,y of the midpoint of a polyline with MS SQL Server? I can get start point and end point by using shape.STStartPoint().ToString() and shape.STEndPoint().ToString() An arbitrary point using…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-25T11:02:46.91+00:00
Shaun Gibbins 0 Reputation points
edited a comment 2024-04-26T05:28:55.1666667+00:00
Viorel 112.5K Reputation points
0 answers

MSSQL - Add Connection Errors

MSSQL Extension Version: v1.19.1 VSCode Version: 1.70.2 (Universal) OS Version: macOS 14.4.1 (23E224) After downloading SQL Server v1.19.1, I ran into the same initial error messages as this issue:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-25T23:26:16.3733333+00:00
Max Zander Scialabba 0 Reputation points
0 answers

How Can I set the right value according to comparison conditition

Hello, i have 2 tables , the first one is a referential of the quality services and the second is a historical tables as bellow the DDL : drop table if exists #oderstatus_quality create table #oderstatus_quality ( id int identity primary key, label…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-03-22T23:48:06.14+00:00
Yassir 201 Reputation points
commented 2024-04-25T07:17:03.4633333+00:00
Greg Low 1,495 Reputation points Microsoft Regional Director
0 answers

EDI cross reference table

Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
asked 2024-04-19T19:37:38.3733333+00:00
Jonathan Brotto 40 Reputation points
commented 2024-04-24T05:25:25.9533333+00:00
Olaf Helper 40,901 Reputation points
0 answers

Unable to start Microsoft SQL Server Migration Assistant for Access

I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
asked 2024-04-24T04:58:52.4633333+00:00
Alister Oram 0 Reputation points
0 answers

Please wait for the user profile service problem

As, i am using sql server 2019 in windows server 2019, while login it got stuck in Please wait for the user profile service and please wait for the profsvc. As i cannot connet my server to internet due to security protocols. This problem happen each day…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,777 questions
asked 2024-04-23T02:55:00.8966667+00:00
Uttam Defence 0 Reputation points
commented 2024-04-23T21:23:18.6266667+00:00
Erland Sommarskog 101.4K Reputation points MVP