February 23, 2006 at 12:14 pm
I wonder if there is a "Last Modified" property for any object so that I can check it somewhere in EM or QA.
Thanks.
February 23, 2006 at 12:28 pm
I dont think you have the last modified property w.r.t objects in the database but you can find out the crdate and schema version in sysobjects tables..
crdate - date of the object created ( if the object is dropped and recreated then it will have latest date)
schema_ver - Version number that is incremented every time the schema for a table changes
-Krishnan
February 23, 2006 at 12:36 pm
That's not what I want.
What I am concerning is, since multiple users can access the database, which tables or sp/fn.. have been modified. It's just like Windows File Explorer, it lets you know when a file is last modified.
February 23, 2006 at 12:57 pm
Sorry we do not have anything in SQL 2000
Amit Lohia
February 25, 2006 at 9:45 pm
One area I consider lacking in SQL ........ One of the things I miss about our AS400 is the depth of information like "Last Used" data .....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply