Logon triggers fire in response to the LOGON event that's raised when a user's session is being established. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. For more information, see DML Triggers.ĭDL triggers run in response to a variety of data definition language (DDL) events. These triggers fire when any valid event fires, whether table rows are affected or not. DML events are INSERT, UPDATE, or DELETE statements on a table or view. ![]() ![]() DML triggers run when a user tries to modify data through a data manipulation language (DML) event. A trigger is a special type of stored procedure that automatically runs when an event occurs in the database server. Applies to: SQL Server (all supported versions) Azure SQL DatabaseĬreates a DML, DDL, or logon trigger.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |