USE yourDatabaseName;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspYourSearchingSPName'
GO
OR
-- to get all sps
USE yourDatabaseName;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
GO
Sunday, November 23, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment