Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    88

    Unanswered: Stored Procedure Last Changed date

    I would like to know what stored procedures were updated recently. The only date I can see is the Creation Date. Any idea if the 'Last Change Date' is available?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    SQL doesn't hold such information and to do so either deploy third party tools or maintain a source control system such as VSS or PVCS.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I think that the crdate is exactly what you want. It shows when the current incarnation of an object was created, not the first time that any object by that name was created. When you recreate a stored procedure, the crdate shows the date of the recreation, not the date you first created a procedure by that name.

    -PatP

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by Pat Phelan
    I think that the crdate is exactly what you want. It shows when the current incarnation of an object was created, not the first time that any object by that name was created. When you recreate a stored procedure, the crdate shows the date of the recreation, not the date you first created a procedure by that name.

    -PatP
    You are right if drop proc and create proc where used but what about alter? Alter does not change crdata field.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Hmmm.... Never checked that!

    -PatP

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    OK, so never use Alter...especially since it's been known to be very quirky with views....

    The benefit of ALTER is that you don't need to worry about GRANTS...

    But if you use Roles, it shouldn't be to big of a deal..

    (and if you use connection pooling and application level authority, it's almost 0)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    88
    To apply my changes, I double click on a stored procedure, apply changes and then click OKAY. This does not change the Create Date.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •