Post reply

Table meta data

  • February 13, 2009 at 12:08 am

    #205513

    Hi,

    How can we know the tables last updated date and who updated it?

    I have SSMS and I have couple of table in one of the databases.

    I don't have administrator access, I have only read\write access to database.

    Is it possible?

    Thanks in advance,

    Venki.

    Thank You

  • February 13, 2009 at 12:48 am

    #943375

    SQL Server doesn’t store this information. If you need to know who updated a table and when it was updated, you need to implement your own mechanism for that. This could be done in a few ways, for example - triggers that write the information into a log table, trace that writes this information, using a third party tool that checks the database’s log and with SQL Server 2008 (enterprise edition only) you can do it by defining an audit on the table.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • February 13, 2009 at 2:09 am

    #943392

    Adi Cohn (2/13/2009)

    SQL Server doesn’t store this information. If you need to know who updated a table and when it was updated, you need to implement your own mechanism for that. This could be done in a few ways, for example - triggers that write the information into a log table, trace that writes this information, using a third party tool that checks the database’s log and with SQL Server 2008 (enterprise edition only) you can do it by defining an audit on the table.

    Adi

    Thanks for your information Adi Cohn.

    Thank You

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

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