SQL Server : find last time user was connected

Question

I have a SQL Server (2000) with a number of accounts which I think are no longer used. Is there any way I can find out when each account was last used?

Alternatively what is the easiest way to create a table of accounts logging on to the server over a period.

Answer 1

SQL Server can audit logins. Read more detail here for SQL 2008 and here for SQL 2000

I do not think you can track login usage unless the auditing is turned on.

You can try this to find out when it was last used:

SELECT accdate, name FROM master.dbo.syslogins