Need guidence on notifing when a new users is added

I have a SQL 2000 satabase that has multiple administrators for it and I nee
d
to know when a new user is added to the server. Can you provide some
suggestions on how to accpmplosh this task?"Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
news:9416DA88-2F96-467A-A5DD-ED051E96A99D@.microsoft.com...
>I have a SQL 2000 satabase that has multiple administrators for it and I
>need
> to know when a new user is added to the server. Can you provide some
> suggestions on how to accpmplosh this task?
Do you mean a new LOGIN or a new USER (or both)?
SELECT name, createdate
FROM sysusers
WHERE createdate >= '2006-01-23T00:00:00.000';
SELECT name, createdate
FROM master.dbo.syslogins
WHERE createdate >= '2006-01-23T00:00:00.000';
You could create a job to run these queries once a day or once an hour and
email you the result.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--