Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: urgent, please help.

    hi all,
    Is there any way to get the updated date for a stored procedure?
    I mean we get the created date, can i get the date when the proc was altered after creating it?
    thanks ,
    harshal.

  2. #2
    Join Date
    Nov 2003
    Posts
    94
    select LAST_ALTERED from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'MyRoutineName'

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    No HanafiH ,
    It didn't work , actually for all the routines it shows the same creation date and last_altered dates.

  4. #4
    Join Date
    Nov 2003
    Posts
    94

    Cool

    I think you should address THAT to Microsoft.

    I quote from BOL:

    LAST_ALTERED datetime The last time the function was modified.

    Hmm.

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    may be.
    is anything wrong with the settings on my box? does it work for u?
    Thanks for the reply

Posting Permissions

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