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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-04 : 08:02:59
|
| stoney writes "Hi,I know I can send a page if SQL server agent stops responding but what if one of the user db stops responding or gets deleted? If I have a db called test in SQL server and it gets deleted then how do I get paged?Thanks in advancestoney" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-04 : 08:06:20
|
| If you're the DBA, why allow other users to drop databases? Simply revoke or deny permissions to create or drop DB's and you won't need to be paged. I'm not sure how useful it would be to get paged after the DB is dropped, kinda like receiving a notification after you or a loved one has been shot: handy, but doesn't really help.This of course also means you need to stop allowing non-DBA's to use the sa login. Create new logins for the users, or even better, use Windows Authentication, and do not grant database create/drop priviliges. |
 |
|
|
|
|
|
Single db monitoring