SQL Server Database Engine

MSDASQL ODBC queries to Linked Servers hang with no response after a couple weeks.

Hi all, Our current setup is a linked server to NetSuite ODBC using MSDASQL 17 as the provider. Everything works and runs fine and fast for about 2 weeks. Then the error will occur. There will be no error message or anything, but the query just…

Cannot connect to SQL Server

Let say i have server A and two sql server, SQL1 and SQL2. When Server A try connect to SQL1 then i got below error from SSMS, but if connect to SQL2 then the conneciton is working fine. Other servers beside Server A can connect to both SQL. A Anyone…

SQL Server 2019 process crashes on specific query

Hello, I have a strange issue where I can crash SQL Server 2019 (fully patched at the time of writing to 15.0.4455.2) by issuing rather simple query with the following prerequisites: there is a multi statement table value function there is a view that…

Microsoft ODBC Driver for SQL Server Version 17.10.000

Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed" Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.

SQL SERVER (MSSQLSERVER) ERROR 1067

Hola, Tengo un servidor con Windows server 2025 y se le instaló SQL server 2022, se le estaban realizando configuraciones de always on y licenciamiento pero se tuvo que reiniciar. En el momento en que encendió el servidor, el servicio de SQL estaba…

create table script for existing table

I want to create a create table script for existing table with indexes

Why am I getting this exit code 14 error in my project logs?

STAR Schema Model Design

Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…

SQL Server 2025 LocalDb installation is missing components

According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…

SQL Server 2022 vs 2019 Query Performance gap

I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…

How can I enforce and manage transparent data encryption on SQL Databases involved in replication and Always On AGs?

1.. How can I easily manage TDE -particularly where Database restores to lower environments and between servers is required frequently? 2.How can I manage TDE on Source and Target databases where transactional replication is currently setup?

Can not install SQL server

I tried to install QL server on my new laptop and seems it's not working at all. Herewith the summary: Summary_TUFA1420250817_20260114_071102.txt I installed using SQL2019-SSEI-Expr, even I tried uninstalled all and tried using SQL2022-SSEI-Expr but…

Steps for Rolling AG Upgrade with new VM's (2016 OS & SQL)

I found the steps for a rolling upgrade of a 2 node AG in place, however I wish to also Upgrade o/s.. Are the steps any different if we add a new upgraded VM to the cluster & join it to AG, then Failover DB from Primary to this New server. Next add…

My SSMS is installed but cannot connect. Error 40. SQL services are running but default instance fails.

My SSMS is installed but cannot connect. Error 40. SQL services are running but default instance fails.

DatabaseMail.exe fails after SQL Server 2022 from CU22 to CU23 - Missing Microsoft.SqlServer.DatabaseMail.XEvents.dll

Product: SQL Server 2022 Enterprise Edition Affected Versions: CU23 Component: Database Mail Summary: Database Mail fails to start or send emails after updating to SQL Server 2022 CU23 (also observed on CU22) with error indicating missing assembly…

SQL volume license not available

SQL server license was purchased through our reseller. Volume license is still not visible on my admin account

Request: SQL Server 2016 ESU Year 3 – Licensing, Cost and Ordering Process

Dear Microsoft Team, we require an official statement regarding "Extended Security Updates (ESU) Year 3" for "Microsoft SQL Server 2016 Standard Edition". System details: -Product: Microsoft SQL Server 2016 Standard…

SQL sever replication error replication is nit installed on this instance while configure distribution wizard

iam trying to configuring sql server replication using the distribution wizard

SQL problem, not finding server type, need some guidance.

Was working with AI help yesterday on a SQL problem and had to pause until today, can I resume with some help? Have limited knowledge as a senior.

Under a Select Plus agreement, there is no product key provided. How can SQL Server be upgraded in this case?

I have purchased SQL Server 2022 Standard. How can I upgrade from the free edition (Express / Evaluation) to SQL Server 2022 Standard? Our organization is under a Select Plus agreement, and we do not have a visible product key—only the License Summary is…