The problem is that after the October 13 (KB5126646) update, connections created by SQL Server linked server queries might remain open. According to Microsoft, "As additional queries are performed, ...
Microsoft confirmed that the October 13 KB5126646 update can prevent SQL Server linked server queries from closing ...
Windows Report on MSN
Microsoft confirms Windows updates are breaking SQL Server connections
Microsoft confirms recent Windows updates cause SQL Server performance and stability issues. An emergency fix is coming.
Microsoft has confirmed that Windows updates released since the October 2026 Patch Tuesday are causing SQL Server performance and stability issues.
The TOP expression doesn't affect statements that might run because of a trigger. The inserted and deleted tables in the triggers return only the rows that are truly affected by the INSERT, UPDATE, ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results