Find when a stored procedure was last modified

Home > Uncategorized > Find when a stored procedure was last modified

August 18, 2010 dananos Leave a comment Go to comments

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

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Network Programming in .NET