Post reply

refdate column in sysobjects table

  • April 20, 2007 at 5:30 am

    #92388

    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

    #701733

    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.

  • June 23, 2010 at 1:21 am

    #1183751

    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

    #1183819

    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