New SQL Server 2005 Features: DDL Trigger
New SQL Server 2005 Features: DDL Trigger
SS05 has a nice feature that allows you to control who is dinking with your tables and what they can do.
“A DDL Trigger can fire after execution of any Transact-SQL event that belongs to a predefined grouping of similar events. For example, if you want a DDL trigger to fire after any CREATE TABLE, ALTER TABLE, or DROP TABLE statement is run, you can specify FOR DDL_TABLE_EVENTS in the CREATE TRIGGER statement. After CREATE TRIGGER is run, the events that are covered by an event group are added to the sys.trigger_events catalog view.” http://msdn2.microsoft.com/en-us/library/ms186406.aspx
SS05 has a nice feature that allows you to control who is dinking with your tables and what they can do.
“A DDL Trigger can fire after execution of any Transact-SQL event that belongs to a predefined grouping of similar events. For example, if you want a DDL trigger to fire after any CREATE TABLE, ALTER TABLE, or DROP TABLE statement is run, you can specify FOR DDL_TABLE_EVENTS in the CREATE TRIGGER statement. After CREATE TRIGGER is run, the events that are covered by an event group are added to the sys.trigger_events catalog view.” http://msdn2.microsoft.com/en-us/library/ms186406.aspx
Labels: ALTER TABLE, DDL Trigger, DROP TABLE, SQL Server 2005
posted by Barry O'Connell at 9:45 AM
0 Comments:
Post a Comment
<< Home