Post reply

Retrieving object create date without using sysobjects

  • June 28, 2004 at 8:07 pm

    #161572

    Hi there,

    does anyone know a way of returning an object's create date in T-SQL, without having to go to the sysobjects table?

    INFORMATION_SCHEMA.TABLES returns only a tiny subset of table-related date, there is no OBJECT_CRDATE system function and even OBJECTPROPERTY doesn't include the create date property, as far as I can tell. 

    Thanks for your help.

     

  • June 29, 2004 at 12:12 am

    #512342

    sp_help '

    '

    I'm guessing it uses sysobjects in the background and it's not much use if you want to use the date in later code.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply