Post reply

Table modification history?

  • March 23, 2005 at 12:55 pm

    #164890

    Does anyone know how to view a table's access history?

    Thanks,

    Mike

  • March 23, 2005 at 1:08 pm

    #548588

    That doesn't exist in sqlserver. You must use the profiler and filter for specific table names (never did that so I can't really help more than that).

  • March 23, 2005 at 1:36 pm

    #548597

    Are you wanting to monitor changes to the table structure, data, or access to the data?

    A Log Explorer tool would allow you to see changes to the data and structure.  Another way would be to create an audit table that logs changes, date/time stamp, and userid.  The only way I can think of to monitor access to the data is as Remi pointed out with profiler.

    Steve

  • March 23, 2005 at 2:07 pm

    #548601

    Thanks.

    Mike

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

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