November 13, 2008 at 7:20 am
Hi Friends,
Basically I need to create an environment where I can get alert whenever any new login or user would be created.
The following below information should store to monitortable which will available in database.
- Login Name / User Name which created
- Name of the Which user created
- Creation Date
- Login Type
Please feel free to ask if any doubt regarding my query.
November 13, 2008 at 7:30 am
The easy way is to check on Syslogins, from there you can see the createdate, updatedate and accessdate of all logins for the server. you can play around with this 🙂
November 13, 2008 at 8:25 am
In SQL 2005 I would go with Event Notifications for CREATE\ALTER\DROP Login. You could also use DDL triggers, but Event Notifications is more suited if you want to send a meesage to an operator or another server.
For SQL 2000 you're only option is to monitor the syslogins table like Crazyman said.
[font="Verdana"]Markus Bohse[/font]
November 13, 2008 at 9:38 am
Take away System Admin rights to every one then they cannot add these logins.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply