• Very nice and an interesting idea for auditing packages. One question: Any issues with a trigger in msdb for patches/service packs? Not sure I like the idea of changing the system tables, but this is fairly minimal.

    I'm still more of a fan of NT auth for connections and auditing as well as having a separate owner pwd for people working on a package, but this is something I'll have to think about.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net