who updated the stored proc?

Is there a way to check who was the last person or list of people who update a given proc in SQL server 2008? Is there a built in utility command, dash board, or 3rd par开发者_运维技巧ty tool out there which can provide this insight?

Thanks

Right-click on the database node in SSMS, choose Reports>Standard Reports>Schema Changes History. This'll give you a list of changes - however, if the changes was not made recently you may not be able to find it on this report - it does not show "all changes, ever"!

Your question indicates you have several troubling problems that need to be addressed.

First you should be using source control and storing all changes to procs in it. Then you can see who made what change and be able to revert to previous versions.

Next, if this problem occurred on production, you need to limit the production rights to only a dba and people assigned a configuration management role (Either configuration pepeople, dbas, or managers). Application developers should not have any rights to create or update objects on prod at all.

You can also set up trigger to monitor and record all changes to databases. Look up DDL triggers.

@Will A gives you a short-term solution but it may not be valid for the research you need if the change was not recent.