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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-08-13 : 23:02:17
|
| I have a tableA in serverA and tableB in ServerB.Now I have a trigger on tableA which updates a record into tableB which fires another trigger which has a few stored procedure to execute.When i inerted a record in Table A this is the error iam getting(I am using linked server)tgr_tbl_emp_master- is a triggererror-message recieved:-Server: Msg 7395, Level 16, State 2, Procedure tgr_tbl_emp_master, Line 9Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF.[OLE/DB provider returned message: Cannot start more transactions on this session.]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096]. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-15 : 16:58:11
|
| Do you really want the update to fail if SerevrB isn't available?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-08-16 : 10:57:40
|
| Yes.If the server B isn't there the update should fail |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-08-16 : 11:31:38
|
| Another error Iam getting when using this comment to temporarily disable the trigger isALTER TABLE SQL_TEST.APS.dbo.tbl_emp_master DISABLE TRIGGER tgr_check_emp_scores Server: Msg 117, Level 15, State 1, Line 1The object name SQL_TEST.APS.dbo.' contains more than the maximum number of prefixes. The maximum is 2. |
|
|
|
|
|
|
linked server problem