Home
> Uncategorized > Find when a stored procedure was last modified
Find when a stored procedure was last modified
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
Comments (0)
Trackbacks (0)
Leave a comment
Trackback