Browse Blog Posts by Tags

All Tags » MSDTC » error (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 27 2009
Filed under: Filed under: sql server, dmv, error, best practices, spid, connections, code, msdtc, kill, rollback, orphan, distributed transactions
The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 11 2009
Filed under: Filed under: sql server, services, replication, error, cluster, msdtc, distributor, subscriptions, linked server, error 7391

Page 1 of 1 (2 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)