Web Development

General discussion

Gravatar
Locked

SQL Server 7.0 Info on Stored Procedures

By lshaw ·
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

SQL Server 7.0 Info on Stored Procedures

by andrew In reply to SQL Server 7.0 Info on St ...

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.

Back to Web Development Forum

Start or search

Related Discussions

Related Forums