Hii I was just reading an article about DDL triggers on MSDN. I created a trigger on my test server CREATE TRIGGER DDL_TRIGGER_1 ON DATABASE FOR DDL_DATABASE_LEVEL_EVENTS AS ROLLBACK RETURN And i found that even when i am using sa login for performing any kind of DDL operation ie CREATE TABLE trigger is fired not allowing me to create table. How come SQL server restricting SA while creating tables. and what is the easiest way to view ddl triggers definition.