• The only way I know of doing this is to turn on AuditLevel property to allow succesful logins to be reported in the ERRORLOG file. You then need to read all the ERRORLOG files to determine the last time the user logged on.

    Gregory A. Larsen, DBA

    Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:qa.sqlservercentral.com/bestof/purchase.asp

    Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP