What Is Transact-sql Ddl Trigger?

1.	What Is Transact-sql Ddl Trigger?
Answer» A special type of Transact-SQL stored procedure that executes one or more Transact-SQL statements in response to a server-scoped or database-scoped event. For EXAMPLE, a DDL Trigger may FIRE if a statement such as ALTER SERVER CONFIGURATION is EXECUTED or if a table is deleted by USING DROP TABLE. A special type of Transact-SQL stored procedure that executes one or more Transact-SQL statements in response to a server-scoped or database-scoped event. For example, a DDL Trigger may fire if a statement such as ALTER SERVER CONFIGURATION is executed or if a table is deleted by using DROP TABLE.

Answer»

A special type of Transact-SQL stored procedure that executes one or more Transact-SQL statements in response to a server-scoped or database-scoped event. For EXAMPLE, a DDL Trigger may FIRE if a statement such as ALTER SERVER CONFIGURATION is EXECUTED or if a table is deleted by USING DROP TABLE.

A special type of Transact-SQL stored procedure that executes one or more Transact-SQL statements in response to a server-scoped or database-scoped event. For example, a DDL Trigger may fire if a statement such as ALTER SERVER CONFIGURATION is executed or if a table is deleted by using DROP TABLE.

Discussion

No Comment Found

Related InterviewSolutions

Is It Possible To Create Trigger On Views?
What Is The Difference Between Instead Of And After/for Trigger?
What Is The Difference Between For Trigger And After Trigger?
When Multiple After Triggers Are Attached To Sql Table, How To Control The Order Of Execution?
How Many Triggers Are Possible Per Table?
It Is Possible To Create Trigger On Views?
Why The Trigger Fires Multiple Times In Single Login?
What Is Logon Trigger?
What Is Instead Of Dml Trigger?
What Is After Dml Trigger?