Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
 Posted - 2012-06-28 : 02:50:36
|
| I had a stored procedure in my database. But all on a sudden i found that the SP has been deleted. Now How can I get details fro the same..Like Who has deleted the SP.When that SP has been deleted etc. I need as much info as possible to retrieve..Thanks in Advancekalyan Ashis Dey |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-06-28 : 07:22:35
|
In object explorer, right-click on the database name, Reports -> Standard Reports -> Schema Change History.I think default_trace had to have been enabled for this to show any data. You can check if it is enabled using this:sp_configure 'default_trace' |
 |
|
|
|
|
|
Get details of a Deleted Stored Procedure