query to find Inactive users in SQL server

Question

Post reply

query to find Inactive users in SQL server

navimir

SSC Eights!

Points: 872
More actions
December 10, 2013 at 7:15 am

#283394

Hi,
Could any1 help me how to find inactive users(e.g users who have not logged in for a long time) in SQL server???

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

eccentricDBA SSCarpal Tunnel Points: 4844 More actions · Answer 1

SELECT name,accdate FROM master.dbo.syslogins

http://technet.microsoft.com/en-us/library/ms178593.aspx

navimir SSC Eights! Points: 872 More actions · Answer 2

SELECT name,accdate FROM master.dbo.syslogins

shows the creation date but i want the last login date when the user logged in for the last time

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

SQL doesn't track that automatically. You'll need custom auditing for that.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

query to find Inactive users in SQL server

Cookies on SQLServerCentral