Saturday , August 18 2018
Home / DataBase / SQL SERVER / step by step Procedure for Creating DDL Triggers (Part-1)

step by step Procedure for Creating DDL Triggers (Part-1)

DDL triggers:

DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords CREATE, ALTER, DROP, GRANT, DENY, REVOKE or UPDATE STATISTICS.

DDL triggers are fired when user performs DDL events(CREATE,ALTER and DROP) in the database. we can define triggers on the current database.

see more for creating DDL Triggers step step by Step

 

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …