Web Development

Ask something
Discussion Locked

SQL Server 7.0 Info on Stored Procedures

0 helpful
1 reply

by lshaw

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

1 reply

by andrew

Here's the answer to your first question:

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.

Hope this helps.

This discussion is closed to new replies.