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 2000 Forums  SQL Server Development (2000)  Cross Database Triggers

Author  Topic  MRIGUY Starting Member 17 Posts Posted - 2001-08-09 : 11:57:22 I need to write triggers that reference data in other databases (all MS SQL 2000). The triggers will also modify data in other databases. Some of the TSQL statements join data from more than one database. The join is my concern. What, if any, are the disadvantages of joining data from more than one database. My concern is performance. Will performance degrade because security needs to be checked again? Will additional connections need to be made that wouldn't if the data was in the same database? Any potential problems with the situation would be appreciated.