April 20, 2007 at 5:30 am
Hi,
Just i 've a query.
Is the refdate column in sysobjects table is showing last access date of the object? If no what is that date?
warmest
Jayakumar K.
Thanks
Jay
http://www.sqldbops.com
April 20, 2007 at 8:17 am
refdate is typically create date, but reserved for internal use by Microsoft. You cannot get the last access date of an object without tracking it with Profiler.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 23, 2010 at 1:21 am
how do we use profiler to capture the modification of objects and store the results in a table?.
Pls help..
SqlIndia
June 23, 2010 at 4:10 am
sqlindia (6/23/2010)
how do we use profiler to capture the modification of objects and store the results in a table?.Pls help..
What version of sql are you using?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply