Post reply

List of SPROCS with creation and alteration times

  • June 12, 2006 at 10:20 am

    #113322

    Please could someone donate a T-SQL script that will return the full list of SPROCS in a specified database with their creation and alteration times.

  • June 12, 2006 at 10:31 am

    #643169

    SELECT SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_CATALOG, CREATED, LAST_ALTERED

    FROM INFORMATION_SCHEMA.ROUTINES

    WHERE ROUTINE_TYPE = 'PROCEDURE'

    ORDER BY SPECIFIC_NAME

  • June 12, 2006 at 10:56 am

    #643183

    I don't really understand what you mean by SPECIFIC_CATALOG and SPECIFIC_SCHEMA.  I am assuming that by SPECIFIC_NAME you mean the database name.  So if I don't have different catalogs and schemas set can I ignore those then? 

  • June 12, 2006 at 11:20 am

    #643193

    Copy and paste it into Query Analyzer.  Switch to the database you want to run it in.  Press F5.  You can leave out SPECIFIC_CATALOG, SPECIFIC_SCHEMA, or whatever else you want to leave out; or you can include everything by using *.

  • June 12, 2006 at 2:08 pm

    #643239

    Last  altered date  is always the same as Created date in SQL 2000. Not sure about 2005 though

     

    Cheers,

     


    * Noel

  • June 16, 2006 at 2:01 pm

    #644421

    sounds like this is heading the way of the discussed-to-death version control..

    Here's a link to a series of articles by Steve on this...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 6 posts - 1 through 5 (of 5 total)

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