Does SQL Server 2005 exsit the trigger ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Does SQL Server 2005 exsit the trigger ?

When the database starts,I want to startup a trigger to do something,how can I do ?
I know there are two kinds of trigger in SQL Server 2005 ,one is DML trigger and the another is DDL trigger,but they can’t monitor the start of database.
Could you tell me ,Is there a trigger for database level in SQL Server 2005 ?
I know there is this kind of trigger in oracle .

Hi, First specify the actual requirement. In DDL , you have trigger which capture Database Scopped or Server Scopped Events. Tell us what kind of activity u want to capture. I have implemented DDL trigger in some of my server and i have blogged my experience.
just have look on this site Madhu