I have just made my first simple trigger!
all i need is to go between servers
the code is
CREATE TRIGGER pop3 ON dbo.test
For Update As
If Update (one)
Begin
Update server1.dbname.dbo.test2 Set server1.dbname.dbo.test2.two = test.one
from test inner join server1.dbname.dbo.test2 on recid =ids
End
check the syntax and it say it checks out and works when referencing table on same server but different servers i get this error:
Another user has modified the contents of the table or view; the datbase row you are modifying no longer exists in the database.
Database error:[microsoft][odbc sql server driver]...can not start more transactions in this session
Could not start a transaction for ole db provider 'sqloldeb'
Please tell me what I'm missing
thanks
all i need is to go between servers
the code is
CREATE TRIGGER pop3 ON dbo.test
For Update As
If Update (one)
Begin
Update server1.dbname.dbo.test2 Set server1.dbname.dbo.test2.two = test.one
from test inner join server1.dbname.dbo.test2 on recid =ids
End
check the syntax and it say it checks out and works when referencing table on same server but different servers i get this error:
Another user has modified the contents of the table or view; the datbase row you are modifying no longer exists in the database.
Database error:[microsoft][odbc sql server driver]...can not start more transactions in this session
Could not start a transaction for ole db provider 'sqloldeb'
Please tell me what I'm missing
thanks
