Hi Gurus,
Is it possible to create a trigger on a table that has Identity field and when a insert is executed to have the new record inserted into another table with an identity field in it. I'm getting this error:
"Server: Msg 7392, Level 16, State 2, Procedure Trig_Clericaltestbak, Line 11
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Only one transaction can be active on this session.]"

Is there anyway around it?

I'm doing testing on our new SQL2000 box and will need to run parallel with our current production box (SQL 7.0). There are a few tables that need to be in real time and the only way of getting that is having a trigger on the production tables and have the triggers do the update, insert, delete in the new SQL2000 box. Is this the proper way of going into it? Can i accomplish the same thing with replication? Thanks you so much!!!

kaze




---------------------------------
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
MS Sql Server LazyDBA home page