To quickly find out who recently changed a stored procedure. First I found the date/time it was last changed …

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
order by modify_date desc

… then in SQL Server Management Studio I right-clicked the Server-Name and chose Reports \ Standard Reports \ Schema-Changes History, and scrolled down to that data/time.

Advertisements

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