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)
 payload of cross-database triggers?

Author  Topic 

lordzoster
Starting Member

29 Posts

Posted - 2007-07-30 : 05:02:26
Hallo, i have some small database with 30 users each one.
I'm using some triggers for auditing purposes, currently they write into database tables, but i would like to move these tables into an external db in order to reduce the database size.
Would it be too much expensive having a trigger to write into an external database?
Could you point me to any tool to monitor and report the load of such server objects?

Thanks in advance

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-30 : 05:08:40
this would be more usefull for your purpose
http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -