Can the Trigger created for one database table fir

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Can the Trigger created for one database table fir

Author

Topic

vinod kumar
Starting Member

1 Post

Posted - 2009-08-17 : 00:37:20

I Vinod,

1) I have databases db1 and db2 in my server.
2) I need to create Trigger for db1.table1 which fires in the another database db2.table1 when ever db1.table1 is INSERED,UPDATED and DELETED.

Any quick reply will be appreciated

Thanks & Regards

K.Vinod Kumar

K.Vinod

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-08-17 : 01:23:18

use three part name (DATABASENAME.SCHEMA.TABLE), and keep in mind that u must have insert permissions in target db.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources