用:dbname.dbo.tablename
如:
create trigger tri1 on db1.dbo.tableA for
insert
as
insert into db2.dbo.tableB select * from inserted
如:
create trigger tri1 on db1.dbo.tableA for
insert
as
insert into db2.dbo.tableB select * from inserted
create trigger tri1 on db1..tableA
for
insert
as
insert into db2..tableB select * from inserted