Alert for create\restore database failed
-
2011년 12월 5일 월요일 오전 10:34
Hi,
I removed create DB rights from users, but i want to recieve alerts, when somebody trying to create DB on server. What error number i could use for this?
I already tried to set severity to 14(insufficient permission), but in this case i only have message
Login failed for user <>. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
This seems to be a garbage message, becouse sometimes i can see this messages in sql log even for my login.
모든 응답
-
2011년 12월 7일 수요일 오전 5:33중재자
Hi Skazimax,
This type of serverity level is treated as the generally error and is not normally possible to get them logged. In your scenario, you may have a try to implement xp_LogEvent to log a user-defined message into SQL Server log file and Windows Event Viewer. For more information about this topic, please refer to this article:
SQL Server Alerts: Soup to Nuts
http://www.simple-talk.com/sql/database-administration/sql-server-alerts-soup-to-nuts/
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.Stephanie Lv
TechNet Community Support
- 답변으로 표시됨 Stephanie LvModerator 2011년 12월 13일 화요일 오전 9:15
.png)
