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
 SQL Server Administration (2005)
 DB detach/attach and DDL triggers

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-10-29 : 16:05:16
Did anyone notice that attach/detach code doesn't fire DDL triggers. Any info on this?

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-29 : 16:34:05
Is info logged in the table?
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-10-29 : 16:42:08
No, the attach/detach events (sp_attach_db, sp_detach_db, CREATE DATABASE ...FOR ATTACH) are not raised. I can understand for the SPs, however the CREATE DATABASE..FOR ATTACH not working is beyond me.

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -