Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doug_Castell
Starting Member
3 Posts |
 Posted - 2011-04-17 : 18:10:12
|
When calling a stored procedure on a linked server, it works fine from Management Studio. declare @recid as varchar(15)exec mylinkedserver.master.dbo.xp_gmnewrecid ‘SYSTEM’, @recid outputprint @recid That works fine. That tells me all my various DTC settings are okay. regardless, I've gone through them on both servers and set them to allow/allow/etc. When I try to exec the same code _from within a trigger, I getquote:
OLE DB provider “SLQNCLI10? for linked server “mylinkedserver” returned message “No Transaction is active.”.
Is there a setting I need to flip to allow triggers to do this or.. ?? Any thoughts appreciated!--Doug CastellGoldMine Guruwww.castellcomputers.com |
|
|
|
|
|
Calling linked server SP within trigger fails