Post reply

View “date modified” of all stored procedures

  • August 30, 2007 at 1:09 pm

    #153788

      Experts,

    I’d like to know whether there is some way in SQL Server 2000 (using script or GUIs) to view “date modified” of all stored procedures or some sp in a database. Please show me how I can do that.

    Thanks in advance.

    johnsql

  • August 30, 2007 at 1:43 pm

    #730579

    I'm interested also if that would be possible.

    Only the datecreated is mentioned in the sysobjects table.

  • August 30, 2007 at 1:54 pm

    #730583

    M$ has always been very careful not to maintain such thing. Sorry for the bad news.


    * Noel

  • August 31, 2007 at 8:40 am

    #730803

    I always write my script and save it to a disk file, using the following general structure:

    DROP PROC dbo.MyProcedure

    GO

    CREATE PROC dbo.MyProcedure

    AS

    -- actual code goes here

    GO

    GRANT EXECUTE ON dbo.MyProcedure TO [MyUserName]

    GO

  • September 4, 2007 at 1:23 pm

    #731312

       Storing a "modified date" of a stored procedure in sysobjects or somewhere else in SQL Server is helpful if SQL Server 2000 did that. And I cannot understand the reason as your word "careful" in your post "M$ has always been very careful not to maintain such thing". The reason is their business purpose, if MS SQL Server 2000 had all functionalities, then less people would need to buy SQL Server 2005 or 2008.

      Thanks anyway.

    johnsql

     

  • September 4, 2007 at 4:26 pm

    #731351

    in 2005 you can get it from

    SELECT

    [name]

    ,modify_date

    ,create_date

    FROM

    sys.procedures

    Because of "new" internal mechanisms implemented ( system db triggers ). Before 2005 no such thing existed and apparently without that it was too hard to get it right.

    just my $0.02


    * Noel

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

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