Post reply

table's log

  • October 18, 2010 at 1:04 am

    #229778

    hi all.

    how to access each table's log for seeing table's modified and other events occurs?

  • October 18, 2010 at 2:41 am

    #1238266

    Tables don't have individual logs.

    Are you looking for DDL changes or data changes?

    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

  • October 18, 2010 at 4:20 am

    #1238293

    Hi,

    MS SQL Server does not maintain Log for specific Table. But offer option like DDL, DML Trigger but I would like to preferred Change Data Capture to achieve that for DML (DELETE, INSERT, UPDATE, MERG) operations.

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

    Ram
    MSSQL DBA

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

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