Are DDL Triggers available with SQL Server 2005 ?

 Posted by Bhakti on 11/13/2009 | Category: Sql Server Interview questions | Views: 2592
Answer:

Yes. They can be defined with create, alter, drop and other DDL statements.
For an example :
CREATE TRIGGER DDL_Trigger
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE, CREATE_TABLE
AS
PRINT 'Get permissions to drop/alter/create table!!'
ROLLBACK ;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Bhakti