RE: Modified Stored Procedure

[allyne]

Hi Everyone,

Is there a way in SQL2005 to find out everyone who has modified a stored procedure and when?

Thanks for your help!

 

[TysonLPrice]

USE AdventureWorks;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspUpdateEmployeeHireInfo'
GO

 

[allyne]

Hi TysonLPrice,

Thanks for the quick response! This gives me the created date and last modified date I also need to know the history of who modifed the stored procedured so If three people modified it I need to know all three people and when each of them modified it. There's an old stored procedure that seems to have some problems and I'm trying to track down who I need to talk to. It went through many many changes and many people.

Thanks again for all your help!

 

[TysonLPrice]

I tried to post that it was missing the user right after my first post but IE froze up. I don't think that kind of history is kept. At my shop the DBAs will not roll out a change without an update to the modification log we maintain in comments.

 

[allyne]

Thats what I thought but was hoping I was missing something...

The comments are currently being maintained....it's now just trying to find out past modifications....

Thanks for all your help!

 

[jbenson001]

YOu should put any of your code in a source control program. We use visual source safe.

 

[allyne]

You're right....we are currently working on that. We're just not quite there yet....