Results 1 to 2 of 2

Thread: How do I identify object modification date under Sql7 and 2000

  1. 05-23-2001, 01:28 PM #1
    Jon Levin Guest

    How do I identify object modification date under Sql7 and 2000

    I used to rely heavily on the sysobjects.crdate under mssql 6.5 to identify the last time an object was updated (primarily sprocs, but also tables and views). With the Sql7 Alter command, there doesn't seem to be any easy way to tell the last time an object was changed. Is this data stored out on any of the system tables/information views?
    Reply With Quote Reply With Quote
  2. 05-23-2001, 02:08 PM #2
    Jon Levin Guest

    How do I identify object modification date under Sql7 and 2000 (reply)

    Found the answer provided by Patrick M in an earlier post. Need to keep a prior day's version of sysobjects and do a comparison of schema_ver and base_schema_ver. Doesn't seem to be a way to get an actual 'mod-date' from just the current system tables...oh well!


    ------------
    Jon Levin at 5/23/01 2:28:58 PM

    I used to rely heavily on the sysobjects.crdate under mssql 6.5 to identify the last time an object was updated (primarily sprocs, but also tables and views). With the Sql7 Alter command, there doesn't seem to be any easy way to tell the last time an object was changed. Is this data stored out on any of the system tables/information views?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules