Mod Date for Stored Procs

  • Is their any way to find a Mod Date on user stored procs? I have a developer who has been makeing changes without keeping track of what he has been doing and now I need to figure out which SP's to move to the production server. I really don't want to move them all.

    Thanks.

  • There are some 3rd party tools but I'm not aware of any system info on this without re-writing the 3rd party software. SQL Compare can compare 2 db's to see what is different. I think Lumigent has a product that can track schema changes.

    Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

Viewing 2 posts - 1 through 1 (of 1 total)

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