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 |
|
mmerlinmento
Starting Member
1 Post |
 Posted - 2012-04-03 : 02:06:17
|
| I would to know the IP address and user name who had deleted the Database ., Please do provide me the sql query for it.,- |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-04-03 : 03:42:52
|
| Check the default trace, it should be logged in there. If it's not, then you are out of luck unless you had come custom auditing in place.--Gail ShawSQL Server MVP |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-08 : 04:15:37
|
| If you can't find it in the default trace - use information from the Security Logs - assuming users are using Windows Logon - to create a list of users who were logged on at the time. It's not precise, but it could give you some ideasJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Find out Who deleted the database