Post reply

Find out if the value in table was modified using SSMS.

  • March 10, 2009 at 8:49 am

    #200588

    Dear All,

    Is there any awy to find out if a anyone has modified a value in table by directly opening the table in management studio..? (Not through any front end software). I want to catch it for AUDIT purpose...

    Thanks.

  • March 10, 2009 at 9:04 am

    #956867

    If you have an audit trigger, check the Application_name() function. If you're using a trace to audit, check the application_name column

    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

  • March 11, 2009 at 11:47 pm

    #958082

    It's same app_name no..?. Thanks I got it.

    Well, wot about host_name()..? which one is better .?

  • March 12, 2009 at 1:56 am

    #958104

    Host_name is the machine name.

    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 4 posts - 1 through 3 (of 3 total)

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