Post reply

When the trigger was DISABLE?

  • June 30, 2008 at 2:50 am

    #77029

    We have our application installed at client sites. Client has disable trigger on one table.

    We would like to know when and who (userid) disable this trigger?

    We haven't set any mechanism to audit such changes.

    Can I get above informatiob from any of the System table maintain by SQL Server 2000.

  • June 30, 2008 at 4:19 am

    #836008

    If you don't have some form of monitoring in place, there's no way to find out that information.

    SQL 2000 does not keep track of when objects were modified or by who.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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