get last updated date of a table

• hussain27syed

  Ten Centuries

  Points: 1191

  More actions

  April 16, 2010 at 7:44 am

  #97271

  Hi,

  Is there any way to find out when the last time a record was inserted or updated on the table.

  I have to find such date for a table in a DB where i have only public access.

  Any help would be appreciated

  Regards

  Hussain

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 16, 2010 at 8:48 am

  #1152884

  Unless there is any auditing solution in place or table has any such date columns its difficult to fetch that.

  MJ