Last Login date

Hi,

How to find out the Last Login date of an SQL Login id in server.

Balavenkatesh

You can do something like this

select * from sysprocesses

Where loginame like ''

order by last_batch desc

|||

In order to view login statisctis you will need to enable the common criteria (CC) compliance option. For more information please refer to BOL (http://msdn2.microsoft.com/en-us/library/bb326650(SQL.90).aspx).

I hope this information helps, please let us know if you have further questions.

-Raul Garcia

SDE/T

SQL Server Engine