This Code will give you the logins created in the last X Days.
you can create a Job on each SQL instance and include this Code and send you notification every Morning/Evening about the logins changed Created in the last X Days.
This Code will give you the logins created in the last X Days.
you can create a Job on each SQL instance and include this Code and send you notification every Morning/Evening about the logins changed Created in the last X Days.
[X is a INT] SQL 2000 version select * from master.dbo.syslogins Where createdate >=getdate()-X [Replace X with Logins created in the last X=number of days] SQL 2005 Version Select * from sys.server_principals Where create_date >= GETDATE()-X [Replace X with Logins created in the last X=number of days]