Looks like somebody has logged in and modified a Stored Procedure on our SQL Server database. Is there a way to find out the credentials of the person that has done that?
You can look at the default trace and figure this out easily. Try the examples from Jonathan Kehayias.
This is to show as an example and you need to look at the ALTER OBJECT event type.
Code is courtesy of Jonathan Kehayias.
This you can find using two different way: First is: default trace file. In which you can find all require field for last modification like, hostname, login user name: Below is script for this:
Reference is taken from this: http://www.dbrnd.com/2015/06/script-to-find-last-ddl-changes-in-sql-server/
Second way: You can use system default view and tables to find last ddl changes using below script:
Reference taken from this url: http://www.dbrnd.com/2015/06/find-most-recently-modified-stored-procedure-table-in-sql-server/