20,672 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

ask about sql server

now my sql data is 100gb + use in microsoft navision use 5 year database setting is basic and auto glow unlimited can you tell me to make small database how to do thank you

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,348 questions
asked 2025-08-11T15:38:44.13+00:00
aka aran 20 Reputation points
commented 2025-08-12T01:26:33.99+00:00
aka aran 20 Reputation points
0 answers

My 2022 SQL Server will not install

I have tried nearly everything that I can think of to make it work, but it refuses to install. The attached files are from an attempt at using the Developer option to download. Screenshot 2025-08-07 210604.png Screenshot 2025-08-07 212904.png

SQL Server | Other
asked 2025-08-08T01:33:08.49+00:00
Elijah Adepeju 0 Reputation points
commented 2025-08-11T22:47:53.8733333+00:00
Elijah Adepeju 0 Reputation points
0 answers

Unable to Create Connection in Power Automate Using On-Prem Gateway - Invalid SQL Credentials Error

Hi Microsoft Support Team, I am encountering an issue of SQL connection in Power Automate. I created a connection to on-prem SQL server using on-prem gateway. Upon creation, it has no issue, it is saved successfully. However, when I ran the workflow, the…

SQL Server | Other
asked 2025-08-11T02:24:42.01+00:00
Alma Chang 0 Reputation points
commented 2025-08-11T20:46:20.6133333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
0 answers

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

SQL Server Database Engine
asked 2025-06-30T11:13:04.09+00:00
Gorla, Siva 5 Reputation points
commented 2025-08-11T19:56:34.1333333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

SQL Cluster Failures After KB5062572 Update on Windows Server 2022

Previous version: KB5060526 (OS Build 20348.3807). After applying KB5062572 (OS Build 20348.3932) to our Windows Server 2022 environment, we experienced SQL cluster failures, including node failover issues, disk/storage errors, and database…

SQL Server | Other
asked 2025-08-06T14:53:43.6566667+00:00
Salvino Sepulveda Jr 0 Reputation points
answered 2025-08-11T18:18:31.4033333+00:00
Valdeir Brito 1 Reputation point
0 answers

importing excel using Import or export

my imput and export data doesn't have the excel imput

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
asked 2025-08-11T00:40:50.2433333+00:00
Jesse Baza 0 Reputation points
edited a comment 2025-08-11T16:54:53.42+00:00
Yitzhak Khabinsky 26,676 Reputation points
0 answers

How do I know what SQL version I have?

I am completing a Cyber questionnair for procurment with a client who is looking to use our SaaS product. A question is "What SQL" version do we use. How do i find out?

SQL Server | Other
asked 2025-08-10T22:47:22.82+00:00
Angie Montgomery 0 Reputation points
commented 2025-08-11T16:52:51.2433333+00:00
Yitzhak Khabinsky 26,676 Reputation points
1 answer

How can I connect to my SQL server from my VM using a .NET application.

I have a .NET application on my azure virtual machine that will not connect to my azure SQL database. I can otherwise connect to the db on my vm using SSMS. My .NET application will connect from my local laptop. I am using ENTRA ID authentication.

Developer technologies | ASP.NET | ASP.NET Core
Developer technologies | .NET | Other
SQL Server | Other
asked 2025-02-07T23:50:29.9033333+00:00
Nicholas Pallotta 0 Reputation points
commented 2025-08-11T11:03:18.3833333+00:00
Raymond Huynh (WICLOUD CORPORATION) 620 Reputation points Microsoft External Staff
1 answer

KB5058713 fails install

KB5058713 fails install regardless of reboots, disabling SQL services, or Safe boot. O/S: Win10 Pro 22H2 x64 Tried: Run WUpdate Troubleshooter - fails to launch due to error 0x80070003 Reboot & Update - install fails Clean boot & Update -…

SQL Server Database Engine
asked 2025-07-09T21:55:03.7266667+00:00
tocguy 40 Reputation points
commented 2025-08-10T14:53:13.52+00:00
XM G 0 Reputation points
0 answers

How is this function suppose to work - clarification needed

Hi, ALL, In https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlstatistics-function?view=sql-server-ver17#comments at the end of this section. there is a following sentence. [quote] If the row in the result set corresponds to a table, the…

SQL Server | Other
asked 2025-08-08T14:02:02.7533333+00:00
Igor Korot 56 Reputation points
commented 2025-08-09T08:33:18.16+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
2 answers

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

SQL Server Database Engine
asked 2025-08-05T14:53:19.4333333+00:00
anna@tec 0 Reputation points
commented 2025-08-08T21:21:48.1866667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

High Memory Usage in SSISDB Related to MEMORYCLERK_SQLBUFFERPOOL

We are using SQL Server 2019. On this server, several content databases (used for reporting purposes) and an active SSISDB are running. The entire system is hosted on a single server where SQL Server 2019 is installed. Occasionally, memory usage on the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
asked 2025-08-07T21:59:33.9766667+00:00
Oktay Bozdemir 41 Reputation points
answered 2025-08-08T19:28:12.2466667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
2 answers

Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."

I can't enable one of my product add-in due to below error message - Unable to find any Microsoft OLE DB providers on the machine. Please install "Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008" or later. …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,348 questions
asked 2020-08-12T09:04:30.717+00:00
Yu, Xiaoxue (Refinitiv) 1 Reputation point
edited the question 2025-08-07T17:40:49.5166667+00:00
Alison A 1,575 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded.

I am using DDD architecture and the following code changes the aggregate Root (basically adds a comment which is an Entity to the aggregate Root). public sealed class AddCommentToPostCommandHandlers : ICommandHandler<AddCommentToPostCommand,…

Developer technologies | .NET | Entity Framework Core
SQL Server | Other
asked 2024-11-24T08:29:09.3733333+00:00
Arman Espiar 1 Reputation point
commented 2025-08-07T12:31:41.1733333+00:00
Đào Quân 0 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server 2019 SSISDB's High Memory Usage

We are using SQL Server 2019 and SSIS on a single server, which runs nightly ETL jobs using SSIS as the ETL tool. Each night, when the ETL processes begin, SSISDB’s memory usage increases significantly. However, even during the day—when no ETL jobs are…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
asked 2025-07-22T09:17:32.3033333+00:00
Oktay Bozdemir 41 Reputation points
commented 2025-08-06T19:17:35.7866667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

How do fix Microsoft SQL server installation issue.

I’m facing an issue with SQL Server Agent and SQL Server services. Initially, both services were not starting. After multiple troubleshooting attempts, I managed to start them successfully. However, I am still unable to log in to the database using SSMS…

SQL Server Database Engine
asked 2025-07-30T11:59:39.59+00:00
Raj Gaur 0 Reputation points
commented 2025-08-07T20:47:28.1633333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
2 answers

Data Synchronization - Syncing Two Databases in SQL Server

I'm needing to take one database and have it on two separate sql servers (in two different physical locations) and have it stay in sync. Is there a way that I can do this? I've looked into SQL Server Replication ie:…

SQL Server Database Engine
asked 2025-08-05T19:47:19.7333333+00:00
Brad 0 Reputation points
commented 2025-08-08T14:00:59.7766667+00:00
Brad 0 Reputation points
0 answers

How to fix ODBC test result failed

When we test our ODBC configuration it fails. This use to work fine, but suddenly it stopped. Here is the error message. "Microsoft ODBC Driver for SQL Server Version 17.10.0006 Running connectivity tests... Attempting connection [Microsoft][ODBC…

SQL Server Database Engine
asked 2025-08-05T22:23:26.59+00:00
SuperCoder 236 Reputation points
commented 2025-08-06T19:59:23.9566667+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

SQL server express not installing

Hi, I have tried to install this multiple times however this error keeps showing up. I have uninstalled it and then tried to reinstall and it hasn't worked. Is there anything else I can try?

SQL Server Database Engine
asked 2025-08-06T12:57:45.6+00:00
Andi King 20 Reputation points
commented 2025-08-07T15:27:17.4633333+00:00
Andi King 20 Reputation points
1 answer

What is the best approach to perform inplace upgrade first . is it OS or SQL ?

Current OS ( 2016)and SQL (2016) versions are going to obsolete and user wants to do inplace upgrade both OS and SQL to version 2022 . What is the best approach to perform inplace upgrade first . is it OS or SQL ? Could you please provide me the step by…

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.
573 questions
asked 2025-08-07T10:32:00.48+00:00
Durga Tota 0 Reputation points
edited an answer 2025-08-07T21:46:53.3433333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator