How can I find out a modification date to a user-created stored procedure? I need to know when the sp was modified. Also, is there a way I can do a compare on two stored procedures, each on a different server?
This conversation is currently closed to new comments.
SELECT crdate FROM sysobjects WHERE name = 'proc_name' and OBJECTPROPERTY(id, N'IsProcedure') = 1
As far as comparing procs across servers, I would say the easiest way would be to run sp_helptext on the procs on each server, then use a text comparison utility (like WinDiff) to do the diff.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL Server 7.0 Info on Stored Procedures