Archive
Archive for August, 2010
Find when a stored procedure was last modified
August 18, 2010
Leave a comment
A handy trick to find when a stored procedure was last modified is with this command;
SELECT * FROM [database].sys.objects WHERE type = ‘P’
This gives the following fields:
name
object_id
principal_id
schema_id
parent_object_id
type
type_desc
create_date
modify_date
is_ms_shipped
is_published
is_schema_published
Categories: Uncategorized
Network Programming in .NET 