14,530 questions with SQL Server | Other tags

Sort by: Updated
0 answers

How to resolve issue of Audit log table containing incorrect data?

We have created a parent table & child table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that…

SQL Server | Other
asked 2025-08-28T09:25:17.3166667+00:00
John 0 Reputation points
commented 2025-08-28T21:27:51.1366667+00:00
Erland Sommarskog 124.9K Reputation points MVP Volunteer Moderator
1 answer

sql cluster failover slower failover when only cluster and client network fails much faster when all networks fail

We have setup a simple two node SQL Server Cluster using SQL cluster (not WSFC windows cluster), plus witness disk, with two network adaptors on each node Cluster network 1 = 'Cluster and Client' / Cluster network 2 = 'Cluster only'. SQL server version -…

SQL Server | Other
asked 2025-08-12T14:58:24.01+00:00
Pal Ban 0 Reputation points
answered 2025-08-28T07:03:27.9666667+00:00
Nam Bui (WICLOUD CORPORATION) 80 Reputation points Microsoft External Staff Moderator
1 answer

SQL cluster cannot failover. SQL services cannot start

Hi, I have a 2 node SQL server cluster which cannot failover. The SQL program and DB are located in the shared disk When we try to failover the resource, it cannot auto failover from node A to B. We need to stop node A, manual active all resource in node…

Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
asked 2024-08-12T04:36:02.9333333+00:00
Chong 871 Reputation points
commented 2025-08-27T12:14:05.32+00:00
Spencer Cook 0 Reputation points
2 answers One of the answers was accepted by the question author.

MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes

Microsoft SQL Server 2019 with GDR 2101 (KB5021125) is installed on a Windows Server 2019 computer. The SQL Server has a self-signed certificate and is configured with Force Encryption = yes. A Windows Server 2012 R2 computer has Microsoft OLEDB…

SQL Server | Other
asked 2023-06-29T16:59:55.2+00:00
Mitch Gershonowitz 25 Reputation points
commented 2025-08-26T22:25:44.45+00:00
Nayak, Lakshminarayan 20 Reputation points
1 answer

I have a two procedure, first one for Insert and the second one for update, When I update the table using "prcImage", it doesn't update. Can anyone help me to solve this. I provide the table and store procedures check it and also I provide the .cs Code

This is my table CREATE TABLE [dbo].[UserProfile] ON [PRIMARY] This is my 1st Store Procedure ALTER proc [dbo].[prcDataSubmit] @fname varchar(20), @lname varchar(10), @contact char(15), @password varchar(50) as begin declare @yy char(4) declare @mm…

Developer technologies | ASP.NET | Other
SQL Server | Other
asked 2025-01-22T21:25:30.67+00:00
Md Khalid Hossain 0 Reputation points
answered 2025-08-26T15:42:09.6466667+00:00
Bruce (SqlWork.com) 79,526 Reputation points Volunteer Moderator
5 answers One of the answers was accepted by the question author.

Exit code (Decimal): -2068052377Error Invalid command line argument. Consult Windows Installer SDK..please help me fixing this

Log folder path C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220218_192800

SQL Server | Other
asked 2022-02-18T14:25:57.053+00:00
Raman R 51 Reputation points
commented 2025-08-25T08:12:01.51+00:00
yash khandelwal 0 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server 2019 Installation Fails due to 0x84BB0001 error code

Multiple feature installations (e.g., Python, R, Database Engine Service and others) fail during SQL Server 2019 express with advanced service installation. The summary reports (see attached) states the same error code and error descriptions for all…

SQL Server | Other
asked 2022-02-21T12:22:21.033+00:00
Paul Rehbein 31 Reputation points
commented 2025-08-24T03:50:20.1233333+00:00
Mubina Begay 0 Reputation points
4 answers

Unable to install SQL server

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,075 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 questions
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.
574 questions
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,349 questions
SQL Server | Other
asked 2024-06-03T08:19:20.6533333+00:00
Cydrx Malla 5 Reputation points
answered 2025-08-23T06:59:41.1233333+00:00
Cydrx Malla 5 Reputation points
5 answers

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

Hi Experts, For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,075 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,721 questions
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,349 questions
SQL Server | Other
asked 2023-01-17T12:13:39.11+00:00
Homer Sibayan 366 Reputation points
answered 2025-08-22T19:37:43.6966667+00:00
eric p 0 Reputation points
1 answer

SQL Server LocalDB Crashes on Windows 11 (c0000005) — Cannot Start Instances

I am unable to start any SQL Server LocalDB instances on my Windows 11 Pro system (Build 22621.5624) with 32 GB RAM and an SSD with 4 KB+ physical sectors. I have tried both LocalDB 2017 (v14.0.1000.169) and 2019 (v15.0.4382.1),…

SQL Server | Other
asked 2025-08-21T03:37:41.56+00:00
Sharma, Jessica 0 Reputation points
answered 2025-08-21T21:16:25.91+00:00
Erland Sommarskog 124.9K Reputation points MVP Volunteer Moderator
1 answer

"Unable to locate package msodbcsql17" when installing on python:3.13 image in Docker

Until a pair of days ago, I had a Dockerfile with these instructions, that allowed me to install msodbcsql17, to be able to connect my project to a MSSQL Database, but for some reason, since 2 days ago it started failing, and we didn't change…

SQL Server | Other
asked 2025-08-14T14:35:29.52+00:00
Efraín Cárdenas 5 Reputation points
commented 2025-08-21T08:39:42.3233333+00:00
Arnau Salinas 0 Reputation points
3 answers

Transaction Log Cannot Be Truncated After Memory-Optimized Filegroup Removal

Hello there, One of our clients is facing an issue with a database where the memory-optimized filegroup was forcibly removed using DBCC CHECKDB (test, REPAIR_ALLOW_DATA_LOSS). The database remains functional, but the transaction log continues to grow and…

Developer technologies | Transact-SQL
SQL Server | Other
asked 2025-02-11T04:59:42.99+00:00
kedar giri 81 Reputation points
edited a comment 2025-08-20T16:59:28.3766667+00:00
Palm Plumb 0 Reputation points
1 answer One of the answers was accepted by the question author.

Why MSDN deprecates the AddWithValue method

I am trying to connect to a SQL Server table and update or register data in a program created in C#. In order to create a program that can take measures against SQL injection and support N prefixes, I am thinking of using the AddWithValue method, a…

Developer technologies | Visual Studio | Other
SQL Server | Other
Developer technologies | C#
asked 2025-02-07T08:02:47.0133333+00:00
nqyuta 80 Reputation points
edited a comment 2025-08-20T15:29:22.9+00:00
TylerH 61 Reputation points
2 answers

Anyone having horrible performance in DPM 2025?

Anyone else experiencing horrible performance with DPM 2025? After upgrading from the latest update rollup of DPM 2022, we have been experiencing major issues that after about a week of operation make the system unusable and requiring reboot. After…

SQL Server | Other
asked 2025-03-26T14:29:30.7333333+00:00
Michael 86 Reputation points
edited an answer 2025-08-20T13:40:48.8733333+00:00
Michael 86 Reputation points
2 answers

How to setup ODBC Connection with Kerberos?

Hello, I'm trying to setup a ODBC connection from Windows Server to Hive data sources. The data sources itself uses a Kerberos for authentication, so it is required kinit or keytab. When i tried to setup the ODBC i always get a error like…

SQL Server | Other
asked 2025-08-18T03:26:18.9166667+00:00
Obi Doe 0 Reputation points
answered 2025-08-20T08:05:22.01+00:00
Bjerre, Henrik 0 Reputation points
3 answers

SQL Server 2019 Installation Error : 0x851a0019

I am trying to Install SQL Server 2019 Developer Edition in my personal laptop for some training purposes. But during installation, I keep getting the 0x851a0019 Could Not Find Database Engine Startup Handle error. I have tried changing the SQL…

SQL Server | Other
asked 2021-06-23T14:51:12.447+00:00
Jashobanta Chakraborty 1 Reputation point
commented 2025-08-19T20:13:55.89+00:00
rac saloumi 0 Reputation points
3 answers

I am unable to download SQL server.While downloading it showing as Opps...Unable to install SQL server(setup.exe).Exit code (Decimal):Error description.Wait on the database Engine recovery handle failed.Check the SQL server error log for potential causes.

I am unable to download SQL server.While downloading it showing as Opps...Unable to install SQL server(setup.exe).Exit code (Decimal):Error description.Wait on the database Engine recovery handle failed.Check the SQL server error log for potential…

SQL Server | Other
asked 2023-03-05T06:36:04.24+00:00
Siva Kalyan Dulipalla 0 Reputation points
commented 2025-08-19T18:10:27.42+00:00
José Abraham Maltez Barrantes 40 Reputation points
6 answers One of the answers was accepted by the question author.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON + SQL Server

Hi Everyone, I am seeking help with analyzing an issue related to SQL Server linked server connections. Here is a description of the problem. All SQL server databases servers are on-premises. Scenario 1: (Working Properly) We tried to connect SQL server…

Azure SQL Database
SQL Server | Other
Microsoft Security | Microsoft Entra | Other
asked 2024-06-14T12:23:18.8466667+00:00
Sushant Yadav 40 Reputation points
answered 2025-08-19T16:57:24.4033333+00:00
Tim Cullen 0 Reputation points
1 answer One of the answers was accepted by the question author.

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 20 Reputation points
accepted 2025-08-19T15:54:17.0166667+00:00
Elijah Adepeju 20 Reputation points
2 answers One of the answers was accepted by the question author.

How to Calculate salary of employee

I am calculating salary using below query SELECT '29' as Total_Days,'28' as Present_Days, (14000 / 29) AS Per_Day, (14000 / 29) * 28 AS Total_Salary; But Total_Salary should be 14000 because Total_Days 29 and Present_Day 29

SQL Server | SQL Server Transact-SQL
SQL Server | Other
asked 2024-04-27T06:08:58.23+00:00
Analyst_SQL 3,576 Reputation points
answered 2025-08-19T09:33:24.4833333+00:00
Hena Ortag 0 Reputation points