Tim
Reputation: 337
How do I know if a database trigger is DROP_TABLE or ALTER_TABLE?
If I create a database trigger in SQL Server 2008 which triggers on both DROP_TABLE and ALTER_TABLE, how do I determine whether this is a DROP or an ALTER?
Upvotes: 3
Views: 92
Answers (1)
Martin Smith
Reputation: 453298
Inside the trigger you can test
SELECT EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]','sysname')
It will be DROP_TABLE or ALTER_TABLE
Documentation for EVENTDATA
Upvotes: 5
Related Questions
- Running 'ALTER TABLE TableName ENABLE TRIGGER TriggerName' for an already enabled trigger SQL Server
- How to find trigger that stopping a table to be dropped
- SQL Server 2005 trigger - how to safely determine if fired by UPDATE or DELETE?
- Dropping Tables within an AFTER INSERT Trigger
- Tracking a trigger from a dropped table
- Determine which table was updated in database level trigger
- How to check if table is available to drop & create a trigger?
- Determine if a table is affected by any trigger
- What table is used in an update trigger?
- Sql Trigger - which table does it belong to?