SQL Server Performance

DDL Triggers in SQL Server 2008

Discussion in 'SQL Server 2008 General DBA Questions' started by Hrishi_nk, Sep 16, 2011.

  1. Hrishi_nk New Member

    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.
  2. Luis Martin Moderator

  3. preethi Member

    You have not mentioned anything about SA in your trigger.

Share This Page