November 12, 2008 at 5:11 am
HI,
I m facing problem with linked server.
we have triggers updating password in one table @local database.if password had change triggers would fire and update same record in another table in another database which is in linked server.
But while updating password locally i m getting error as given bellow
Script:
Update MHC_USER_PWD
SET USER_PWD = 'TEST'
Where CLIENT_ID = 1 and USER_ID = 1
Error :
OLE DB provider "SQLNCLI" for linked server "B1MESQCPD" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Procedure MHC_USR_PWD_TG, Line 19
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "B1MESQCPD" was unable to begin a distributed transaction.
Please any solution let me know.
Dharmabhushan
November 12, 2008 at 6:27 am
Sounds like MS DTC is not running on one of the servers.
This is one reason actions that rely on resources outside the current database within a trigger is not recommended as this rolls back changes you need want.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply