Post reply

Help me with this

  • June 1, 2009 at 3:53 am

    #205574

    Hi Expertz

    Can you please tell me what does this select statement return and what is the column "last_altered" stand is it really the last time any modifications done to the stored procedure or is it the last time it was referred to

    select *

    from information_schema.routines

    WHERE

    Routine_Type='procedure'

    AND specific_Catalog='database'

    Tanx 😀

  • June 1, 2009 at 4:08 am

    #1002631

    http://msdn.microsoft.com/en-us/library/aa933197(SQL.80).aspx

    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