Recently i came across this questions, "Is it possible to create a trigger on a table, which is in another database"
No. We can't create triggers on different database. If we try to create, we will receive an error like below.
Cannot create trigger on 'tablename' as the target is not in the current database.
SQL Server Interview Questions · · · ·