|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
Problem using a linked server in an insert trigger
I'm writing an insert trigger in one SQL Server database that is supposed to insert another record into a linked SQL Server database. I have the linked server set up and have been using it for a few weeks in queries and stored procedure with no problem. Now that I'm trying to use it within a trigger and it just bombs.
I'm getting the following message in one of my logs and I don't know what it means... "Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE". I've googled around, but can't really find anything. Any help would be appreciated. Thanks, Bryan |
|
#2
|
|||
|
|||
|
I started the MS DTC service and I no longer get those error messages, but the problem still remains.
![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Problem using a linked server in an insert trigger |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|