18,642 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
4 answers

SQL Statement taking long to execute

I have two SQL Databases that is on the same SQL server but on one database it only takes 4 seconds to complete the SQL statement but on the other SQL database it takes 25 minutes to complete. Both databases uses the same SQL elastic pool and I don't see…

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.
13,323 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
66 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,597 questions
asked 2024-07-15T03:15:50.06+00:00
WingHong Shiu 5 Reputation points
answered 2024-07-21T20:58:04.8166667+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

Protocol Error in TDS Stream in SSIS - connected host has failed to respond

Hello, We are having issue when we are running SSIS package and getting following error: Code: 0xC0202009 Source: Sync Details Data FLow sqlssis OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…

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,323 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
asked 2024-07-21T00:17:48.94+00:00
Pds 46 Reputation points
commented 2024-07-21T20:35:38.48+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

Application unable to connect to Listener intermittently on port 1433

We have a named instance that's running on a dynamic port, with a Listener specified on port 1433. All application strings only specify the listener IP and port. A scheduled job connects to the listener once a day, but it sometimes fails with the error…

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,323 questions
asked 2024-07-21T04:05:37.09+00:00
Amisha Bhadauria 0 Reputation points
commented 2024-07-21T20:31:02.3166667+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

How to access database by External Datasource using Service Principal Name(SPN)

I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,079 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,323 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,761 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,543 questions
asked 2024-07-21T14:42:53.0533333+00:00
Devendra Parmar 0 Reputation points
commented 2024-07-21T20:25:00.38+00:00
Erland Sommarskog 106.5K Reputation points
9 answers

unable to install sql server exit code -2068052377

I was using 2018 ssms with sql server and it worked up to a few days ago. I've tried several ways to fix this. I ran repair setup and goes thru the repair but still have the issue. I uninstall and reinstall. I check service.msc and and tried 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.
13,323 questions
asked 2022-07-05T15:16:37.617+00:00
John Burks 11 Reputation points
commented 2024-07-21T20:14:16.7266667+00:00
Erland Sommarskog 106.5K Reputation points
3 answers

Visio Professional 2019 Currently selected visio driver is not compatible with data source.

I am using brand new copy of Visio Professional 2019, and SQL Server version 15.0.2080.9, both installed on a stand-alone Windows 10 machine. I am using the Reverse Engineering wizard. No matter what ODBC driver I select, or what level DSN it is…

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,323 questions
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
251 questions
asked 2021-04-19T01:10:48.14+00:00
jchatton1 6 Reputation points
commented 2024-07-21T12:25:27.01+00:00
Roger Schmidt 16 Reputation points
2 answers

Recover Resource Group and SQL Server and SQL DB within

I deleted an old Resourge Group with SQL DB within, can i recover within Azure Portal? We have no Backups.

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.
13,323 questions
asked 2024-04-22T14:16:11.3833333+00:00
Helpdesk Milestone 0 Reputation points
commented 2024-07-21T10:15:11.4366667+00:00
Vinodh247 13,301 Reputation points
3 answers

Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.

Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…

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.
13,323 questions
asked 2024-05-04T23:34:12.1833333+00:00
Albert Kirpach 0 Reputation points
commented 2024-07-21T10:14:26.0166667+00:00
Vinodh247 13,301 Reputation points
5 answers One of the answers was accepted by the question author.

SQL Server 2019 Maintenance Plan Tasks Toolbox Missing

Unable to add tasks to new maintenance plan because there is no Maintenance Plan Toolbox. How can we create or recover this Toolbox? This is a new install of SQL 2019 and first time adding maintenance plan on this server.

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,323 questions
asked 2022-03-25T18:23:12.08+00:00
John Robinson 26 Reputation points
answered 2024-07-21T05:27:04.0533333+00:00
RUPERT EDANG 0 Reputation points
5 answers One of the answers was accepted by the question author.

Is there a 64 bit SSMS?

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…

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,323 questions
asked 2021-09-29T11:48:06.173+00:00
子明 李 21 Reputation points
commented 2024-07-21T01:35:57.8133333+00:00
Yitzhak Khabinsky 25,726 Reputation points
2 answers

Bacpac file won't restore due to columnstore indexes on columns with specific data types.

Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…

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.
13,323 questions
asked 2024-07-19T09:58:51.94+00:00
Mark van Eck 56 Reputation points
commented 2024-07-20T21:38:15.0566667+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

Server infected with arthur virus

Server infected with arthur virus. all file extensions are with ,arthur . I need help knowing if I can access data from another server, I am currently on "East US 2" and want to use the "west us" backup. What recommendations do you…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,560 questions
Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,444 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,323 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,600 questions
asked 2024-07-20T15:55:46.3166667+00:00
Victor 0 Reputation points
commented 2024-07-20T21:19:31.2266667+00:00
Erland Sommarskog 106.5K Reputation points
2 answers

Discrepancy in results when running TSQL query with iif

Hi, SQL server version: running on Azure Sql Database 12.0.2000.8 RTM SQL Azure DB compatibility level 160 I am getting discrepancy with the following results, the same thing with case statement, and with patindex. declare @inputString nvarchar(max)…

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,323 questions
asked 2024-07-20T16:53:49.1566667+00:00
Mansa 0 Reputation points
commented 2024-07-20T21:17:06.6633333+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

MY SQL SERVER INSTALLATION ERROR

Hello everyone, I'm currently on Win11 Pro 23H2. I have installed and uninstall My SQL express couple times but having no luck in success installation. I didn't know the cause of this issue. Hope you guys could get me a possible fix Thank you and Best…

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,323 questions
asked 2024-07-19T14:04:23.9566667+00:00
Đình Khoa 0 Reputation points
commented 2024-07-20T21:12:22.8433333+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

Questions about always on’s data synchronization method

Hello I am curious about data synchronization of secondary in always on. Secondary confirmed that the redo thread reads the log cache or redo log file and synchronizes it to the data file and index file. I have doubts about the synchronization method…

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,323 questions
asked 2024-07-20T04:10:57.85+00:00
MINJAE KO 0 Reputation points
commented 2024-07-20T21:10:22.46+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

SQL Server 2022 Developer Edition failing install with error code -2068052310

I'm trying to install SQL Server 2022 Developer Edition and am getting an error stating that an installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found and giving me the exit code -2068052310. I've downloaded and…

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,323 questions
asked 2023-11-12T03:58:22.8866667+00:00
Angel Van de Feniks 1 Reputation point
commented 2024-07-20T15:27:18.3333333+00:00
Chris Smith 10 Reputation points
1 answer One of the answers was accepted by the question author.

Server container is always restarting

We are deploying our backend using an Azure web app. We decided not to use serverless Azure Functions based on our experience with Firebase functions, as they usually do not allow file uploads within the same application. On Azure, the problem is that…

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,323 questions
asked 2024-07-09T10:10:39.21+00:00
Adeola Folarin 20 Reputation points
accepted 2024-07-20T11:26:04.6333333+00:00
Adeola Folarin 20 Reputation points
1 answer

How to talk to a SQL Database in Azure Gov from a Teams chat?

How alk to a SQL Database in Azure Gov from a Teams chat?

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,323 questions
asked 2024-07-19T18:49:00.4066667+00:00
johon sahu 0 Reputation points
answered 2024-07-19T21:39:02.86+00:00
Erland Sommarskog 106.5K Reputation points
0 answers

Issue with SQL Server compatibility level 2022 and sp_executesql

One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…

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,323 questions
asked 2024-07-19T20:07:28.8033333+00:00
Eckels, Adam 0 Reputation points
commented 2024-07-19T21:37:09.9566667+00:00
Erland Sommarskog 106.5K Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

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.
13,323 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-19T21:34:10.5+00:00
Aleksey Vitsko 20 Reputation points