Technical Article

Logins 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]

Rate

4.11 (9)

You rated this post out of 5. Change rating

Share

Share

Rate

4.11 (9)

You rated this post out of 5. Change rating