Home > Uncategorized > SQL Server – Check when stored proc were modified

SQL Server – Check when stored proc were modified

SELECT TOP 1000 [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]

FROM [RPT1].[sys].[all_objects]

where type_desc=’SQL_STORED_PROCEDURE’

order by modify_date desc

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: