Post reply

dml triggers

  • October 6, 2009 at 6:57 am

    #215108

    can anybody explain me where does dml triggers store .

    I created trigger in one of our database .I can't see trigger i created in triggers node SMO

  • October 6, 2009 at 6:58 am

    #1062209

    DML triggers are stored against the table you created them against. In SSMS expand the table you created it on and look in the triggers node. if it isnt there try refreshing your tables node in SSMS.

  • October 6, 2009 at 7:03 am

    #1062211

    As previous poster said check it under the table you created it on. If you still cant view it then there might be some permission issue. Check for trigger presence by querying sys.triggers or sys.objects under that database.

    http://msdn.microsoft.com/en-us/library/ms188746.aspx

    MJ

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply