July 10, 2007 at 4:24 pm
I cannot remember this, as I have not been in a database admin role in some time. I have been more of a developer.
So here is my question....
What is it called where you can be notified when someone creates an account, or an incorrect login, or a database out of space. I want to be notified when something like that happens in a database. I just cannot remember the name, I am thinking an alert. But I want to be positive, so that I can create some on the databases that I am now an admin.
Thanks
Andrew SQLDBA
July 10, 2007 at 8:39 pm
You can create triggers to alert you when a login is created.
Regards..Vidhya Sagar
SQL-Articles
July 10, 2007 at 10:48 pm
Mmmm, you can't actually create a trigger on a system table.
Alerts are the way to go. In Enterprise Manager, got to Management--> SQL Server Agent --> Alerts
If you create an Alert on Error number 15298, you can get notification of the creation of a new login.
July 10, 2007 at 11:29 pm
Yes you can't use triggers with system tables in 2000 only way is to use alerts but i have seen most times that does not work for some reason. If 2005 go for DDL triggers.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 11, 2007 at 8:42 am
Thank you everyone.
Andrew SQLDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply