19,200 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Executing parameterized query with spatial functions

We want to use SET PARAMETERIZATION FORCED on a DB due to unstable Plan Cache caused by third party applications like https://geoserver.org/ and https://mapserver.org/ We have tables with spatial data and when querying them with spatial functions then we…

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,785 questions
asked 2024-10-04T13:07:58.2733333+00:00
Peter Riis 0 Reputation points
commented 2024-10-05T17:49:47.4266667+00:00
Erland Sommarskog 111.1K Reputation points MVP
0 answers

after running the query where the result is displayed in only two columns and rest is not in result, how fix the 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.
13,785 questions
asked 2024-10-05T04:51:38.8166667+00:00
Avinash Goud 0 Reputation points
commented 2024-10-05T09:30:40.6133333+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

DB Size increased on alter column DATETIME TO SMALLDATETIME

Hello everyone. I ran the output of the below code and My database size increased by 30%. Overview: I have millions of records on 100s of tables and tried to see how to reduce space on large tables. I converted large number of SPECIFIC int columns…

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,785 questions
asked 2024-10-04T20:57:16.8433333+00:00
RJ 166 Reputation points
commented 2024-10-05T09:10:25.31+00:00
Erland Sommarskog 111.1K Reputation points MVP
0 answers

Multiple SELECT CONTAINSTABLE conditionals

I have a SQL code that exceeds the 4000 character limit and I'm trying to split it. I want to perform 2 o more SELECT CONTAINSTABLE (there may be more) with the second Select being conditional on the first in AND/OR mode. If the condition is AND 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,785 questions
asked 2024-09-23T03:23:37.85+00:00
zequion 446 Reputation points
edited the question 2024-10-05T03:54:04.8166667+00:00
zequion 446 Reputation points
3 answers

Queries are limited to 4000 characters.

I am working on a semantic search engine and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters. I have encountered the problem that the parameter “contains_search_condition” of the Contains or…

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,785 questions
asked 2024-09-19T04:19:40.1633333+00:00
zequion 446 Reputation points
edited an answer 2024-10-05T03:52:23.7666667+00:00
zequion 446 Reputation points
2 answers

What does ADF SSIS Error "Disk Full Exception Caught" mean

Hi, we are running an Azure-SSIS Type Integration Runtime in Azure Data Factory. This morning this IR suddenly got Unavailable for some reason. Fortunately we had the Diagnostic Settings ADFSSISIntegrationRuntimeLogs enabled and I found the following…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,680 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2024-09-25T10:26:26.61+00:00
Cedric Ahlers 35 Reputation points
commented 2024-10-05T01:33:45.2433333+00:00
Chandra Boorla 1,810 Reputation points Microsoft Vendor
7 answers

Svchost Issue - user profile service - Server 2022 high memory usage

Recently I have install 3 windows server 2022 with mssql 2019. Every two days the system stuck, and I find user profile service consume all the free memory. it's not happens on servers without sql. Btw: I'm not sure if it have something to do but we are…

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,785 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,053 questions
asked 2023-07-05T18:34:52.1633333+00:00
אריאל ווינברג 5 Reputation points
edited an answer 2024-10-05T00:23:05.7566667+00:00
Benjamin Jensen 0 Reputation points
1 answer

Unable to install SQL Server (Setup.exe) Exit code(Decimal) : -2068052377Error Invalid command line argument.

This is what I have tried. Removing any file that has sql written in it from the control panel add or remove the program section. Removing Sql express from Program Files and Program Files (x86) and also removing the C/SQL2022. Deleting these from 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.
13,785 questions
asked 2024-10-04T00:23:22.79+00:00
Farhan Sarang 0 Reputation points
commented 2024-10-04T23:07:37.7333333+00:00
Farhan Sarang 0 Reputation points
1 answer

How to track what triggered memory grant pending

I have a test SQL server, it is lightly used. Recently I got some sql alerts a couple of times daily random time, the alert is like below, I cannot find what caused this, how can I track it and find the root cause? And when I got the alert, I ran dmv…

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,785 questions
asked 2024-10-03T23:55:38.7866667+00:00
AnneW 81 Reputation points
answered 2024-10-04T22:11:17.1166667+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

some columns missing after migration from 2005 to 2019 using data migration assistant

Hi, I am going to migrate a DB from sql server 2005 to 2019 using data migration assistant, there are some tables contain the column "rowguid" which is created due to replication, however when I migrate the DB from 2005 to 2019, this column…

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,785 questions
asked 2024-10-04T07:32:36.53+00:00
Henry Yeung 0 Reputation points
answered 2024-10-04T22:03:24.7066667+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

SQL Server Connection Error (Win32Exception: Unknown error (0x89c5010a))

I am encountering an issue while attempting to establish a connection to SQL Server. The following error message is displayed: Win32Exception: Unknown error (0x89c5010a) SqlException: A network-related or instance-specific error occurred while…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 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,785 questions
asked 2024-10-04T07:48:13.05+00:00
Haleniuk Maksum 0 Reputation points
commented 2024-10-04T21:59:00.6166667+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

Installation Issues with Microsoft SQL Server 2014 and Visual C++ Redistributable, SQL server 2014

SQL Server 2014 Installation: During the installation, I received an error message related to the Windows Installer file: Microsoft.VC80.CRT, version="8.0.50727.42", type="win32", processorArchitecture="x86",…

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,785 questions
asked 2024-10-04T12:36:14.1033333+00:00
Suhail pc 0 Reputation points
commented 2024-10-04T21:50:13.49+00:00
Erland Sommarskog 111.1K Reputation points MVP
0 answers

How to fix Couldn't remove the user xx from database xx from the external libraries folder, error: 0x80070003

Hi Team, One of my client machine I can see lot of error message like " Couldn't remove the user XX from database XX from the external libraries folder, error: 0x80070003 Can you please suggest what is the issue and fix for it. SQL server 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.
13,785 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
asked 2024-10-04T12:38:59.1866667+00:00
Uday Paleti 20 Reputation points
commented 2024-10-04T21:49:13.22+00:00
Erland Sommarskog 111.1K Reputation points MVP
0 answers

Entra ID Authentication Issues for SSIS Deployment in SQL Server 2022

The scenario involves two users, both configured with Entra ID and the sysadmin role for SQL Server 2022. While one user can successfully deploy SSIS projects to the target SSIS catalog, the other user encounters an error message stating: "The…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,696 questions
asked 2024-10-04T21:14:32.7466667+00:00
David B Forbush 0 Reputation points
0 answers

Api-Web app (webjobs) connection to On-Premise SQL Connection

Hi , I am having trouble establishing connection from azure webapp to on-premise sql server. we have virtual network gateway and site-site vpn to sql server. allowed port 1433 in on-premise firewall and in azure firewall as well. webapp have private…

Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,528 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,785 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
925 questions
asked 2024-10-02T22:17:03.1433333+00:00
kvidhul-3447 20 Reputation points
commented 2024-10-04T21:07:05.56+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

How to solve the error 2068052377?

error while installing ms sql 2022 express edition basic installation Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed…

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,785 questions
asked 2024-10-03T17:00:33.4233333+00:00
Chanchal 0 Reputation points
commented 2024-10-04T21:02:38.73+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

SQLServerException: An item with the same key has already been added.

Running the query: SELECT name FROM [" + catalog + "].sys.schemas ORDER BY name I got exception: 10:05:26 [com.microsoft].sqlserver.jdbc.SQLServerException: An item with the same key has already been added. RequestId:…

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,785 questions
asked 2024-10-03T17:18:28.88+00:00
dprutean 0 Reputation points
commented 2024-10-04T20:12:10.5666667+00:00
Viorel 117.2K Reputation points
1 answer

Cannot connect to SQL Database. Please contact SQL server team for further support.

Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a

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,785 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,680 questions
asked 2024-10-01T08:13:02.49+00:00
Ninoslav Zekic 10 Reputation points
answered 2024-10-04T18:42:40.8533333+00:00
Sai Raghunadh M 390 Reputation points Microsoft Vendor
1 answer

Azure SQL Database

Hello I have a question about something that is happening to me regarding access to SQL Databases When I give a group or a user, after creating the Login in the SQL Server, access to the databases that it contains within that same SQL Server, if I give…

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,785 questions
asked 2024-09-18T18:06:43.83+00:00
Fernando Gutierrez 180 Reputation points
commented 2024-10-04T18:32:14.9466667+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
0 answers

Microsoft Download Center - All Download Links Broken

All KB articles that link to the Microsoft Download Center appear to be broken. Ex: KB5042207 - Description of the security update for SQL Server 2016 SP3 GDR: September 10, 2024 How to obtain and install the update -> Method 3 Microsoft Download…

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.
5,384 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,785 questions
asked 2024-10-04T12:12:55.9166667+00:00
Dave_2123 0 Reputation points
commented 2024-10-04T17:31:17.82+00:00
Dave_2123 0 Reputation points