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 |
|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 2004-10-01 : 12:41:04
|
| Hello,Is there a way to find out when someone dropped a database. I created a Database and Dropped that database but I could not find that information in my SQL Server Logs. After I deleted the database there is no record of my dropped database in the sysdatabases table. Is there a table where SQL Server will store this kind of information.Thanksmaximus |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-01 : 12:53:16
|
| no, I don't believe there is anything that keeps track of this.you could probably rig something up by monitoring sysdatabases, but wouldn't it be easier just to not give anyone but the DBA the privelege to drop tables?EDIT:of course I meant to say drop databases. Sorry if that was confusing.-ec |
 |
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2004-10-01 : 13:09:02
|
| Thanks ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-02 : 10:29:15
|
| try a log reader |
|
|
|
|
|
|
History of Dropped Databases