Click here to Skip to main content
15,881,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I had a stored procedure with set of codes. But suddenly some one has changed some code in the Proc and has altered the script. I dont know who has done it or from which system the procedure is been modified. Only I can see is last modified date and time. Is there any possible way to trace the system from where the script has been modified.? Please help.

Thanks in advance.

What I have tried:

SELECT name n1 , create_date n2 , modify_date n3,* FROM sys.procedures
order by modify_date desc;
It only has date modified not the user or system.
Posted
Updated 21-Apr-16 1:51am

1 solution

There is a built-in report that shows this. From Sql Management Studio right-click your db, choose Reports, Standard Reports, Schema Changes History. That will show who changed it last.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900