Trigger on system table

  • Hello Everyone,

    Does anyone know if a trigger can be written against an update of a system table in SQL 2005?  I would like to write an "Instead of" trigger against a mirroring table in msdb.

    TIA

    Elliott

  • This was removed by the editor as SPAM

  • It should be possible as long as you have the perms to do it, but I am sure that MS does not support it, since you could damage your msdb instance that way. 

    If msdb stops working because you added a trigger that has some bad effect, you are on your own :}

    ---------------------------------------
    elsasoft.org

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

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