Advertisement

06.03.2008 at 07:37AM PDT, ID: 23453291
[x]
Attachment Details

How to find the last login date and time of users

Asked by ktuser in MS SQL Server, Databases Miscellaneous, SQL Query Syntax

Tags: Microsoft, SQL Server 2000 or above

Hi,
In SQL Server 2000 ( or above), is there a way to find out users last login date and time? Which system table keeps the record of users last login?

Thanks for your help.

Regards,
Ktuser.Start Free Trial
[+][-]06.03.2008 at 07:44AM PDT, ID: 21700885

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Databases Miscellaneous, SQL Query Syntax
Tags: Microsoft, SQL Server 2000 or above
Sign Up Now!
Solution Provided By: cs97jjm3
Participating Experts: 2
Solution Grade: B
 
 
[+][-]06.03.2008 at 07:52AM PDT, ID: 21700977

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628