SQL Server

CDC change Data Capture on High availibility AlwaysOn 2019

Hello,  I have three nodes (SQL Server 2019) Always On availability group configuration -FYI. I have applied the CDC (Change Data Capture) jobs [cdc.DBName_capture] and [cdc.DBName_cleanup] on all three nodes. However, when a failover occurs from the…

My SQL server exits after running for a few seconds in docker

Hi, I tried running MS SQL server in docker and it exiting withing a few seconds. I am running this on my MAC book. I want to connect Azure data studio to it. Can you please let me know a command that works. I have tried several options and nothing…

Broken upgrade from SQL Server 2017 to 2022

Hello, SQL Upgrade was started at 2026-02-08 17:52:04. End time was logged as 2026-02-08 17:52:15 with final result "Pending". But in the Detail.txt file I see that last log entry is about 18:10. How can I recognize what is the reason of the…

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…

I cannot download the software

It appears that the account you login to your computer with does not actually have full Administrator rights, which is a requirement for installation of the 4-CU and dependent software (SQL..., etc.). Contact your IT department so that they can: …

STIntersection() hangs forever

Hello, when I execute this STIntersection() query for two valid polygons (in this case CurvePolygons), it will run forever and will cause (very) high CPU usage! The problem exists at least from SQL2016 to SQL2025 (with latest updates installed). See…

Syntax error in the statement

Hi, I wrote the following query and trying to figure out the syntax error: incorrect syntax near WHERE. DECLARE @SQL NVARCHAR(MAX) SET @SQL = (SELECT 'SELECT COUNT(*) FROM rv.' + table_name, +','+ QUOTENAME((table_name) + ' as table_name ' FROM…

What is SQL error ID 8179 and how to fix it?

The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV.  It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”).  This issue often occurs when…

server 2025 upgrade cause large files to fail during port forward

when files are port forward after the sever 2025 upgrade they fail Moved from Microsoft 365 and Office | Other

optmization tecniques.

Wants to check query optimization tecniques.please guide SELECT FileName, FileDate FROM BROK.BROK_Staging ORDER BY FileDate DESC Join: https://teams.microsoft.com/meet/44686160893216?p=iDBacftSUDKBlVGWuf

An error was raised while trying to open the database

I am opening tickets with everyone since I am stuck on the attached error when opening compress.

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005)

SSIS package fails to read file from UNC path in SQL Server Agent job (Error 0x80004005) We have an SSIS package that reads data from a file on a network share (UNC path). For example, the file is located at \\EXAMPLE_DOMAIN\SharedFolder\file.csv (domain…

Can a SQLServer 2016 AG with one database be setup with two separate Managed Instance Links?

I’m planning a migration of a SQL Server 2016 Always On AG with a single 4TB database to Azure SQL Managed Instance. We already have one MI acting as a read‑replica for reporting and analytics. As part of the migration, I’m considering deploying a second…

Unable to login On-Prem SQL server

Hi Team, We are not able to login On-Prem SQL server. Could you please help with this.

Informatica to MS SQL Connections hold locks and block

Informatica to MS SQL Connections hold locks and block

SQL Server 2025 Standard Key not working for Power BI Report Server

I am attempting to convert my evaluation edition of Power BI Report Server to a fully activated. I have read in both of the articles linked below that the exact same key used to activate SQL Server 2025 Standard (17.x) is what you should use to activate…

How to fix error received while inserting into table through report builder into oracle database

I am trying to insert records through report builder into oracle database and it is showing dataset related error

Database is disappearing

Every time I create a table, it stays for a while (as long as 24 hrs), and I see it gets dropped. I get resource not available. Why am I losing the database?

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

unable install sql on on pc due to power shell error

unable install sql on on pc due to power shell error