Keep Track of user logins 
Author Message
 Keep Track of user logins
Hello, I'm using ASP(with Javascript)and a SQL db, and I'm
very new to SQL Servers. I have the site working, but on
my admin section I need to keep track of how many times a
user logs in, and the date of the last login.

Can someone point me in the right direction? I'm not sure
where to start!

Thank,
ROB



Wed, 24 Mar 2004 00:44:34 GMT
 Keep Track of user logins

Answer is Auditing. You can get this from SQL Profiler. You can get more
info in BOL.


Quote:
> Hello, I'm using ASP(with Javascript)and a SQL db, and I'm
> very new to SQL Servers. I have the site working, but on
> my admin section I need to keep track of how many times a
> user logs in, and the date of the last login.

> Can someone point me in the right direction? I'm not sure
> where to start!

> Thank,
> ROB



Wed, 24 Mar 2004 01:09:51 GMT
 Keep Track of user logins
Rob,

You can audit successful and failed logins, sending them to the SQL Server
log, by choosing the options in the Server Properties Security dialog in
Enterprise Manager.

To catch the date, as Ramesh says, you'll can use Profiler. Better yet, use
the SQL Trace stored procedures and save the results to a table.

HTH,
Ron
--
Ron Talmage
SQL Server MVP


Quote:
> Hello, I'm using ASP(with Javascript)and a SQL db, and I'm
> very new to SQL Servers. I have the site working, but on
> my admin section I need to keep track of how many times a
> user logs in, and the date of the last login.

> Can someone point me in the right direction? I'm not sure
> where to start!

> Thank,
> ROB



Fri, 26 Mar 2004 04:37:51 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Question: Keeping track of logins

2. Keep Track of Excluded Users for each record

3. Transferring logins/users/logins

4. Counting SQL net connections, tracking logins

5. Tracking Logins

6. Tracking SQL Logins

7. using sql trace and alerts to track failed logins

8. Tracking concurrent logins

9. logins tracking SQL6.5/SQL7

10. Tracking failed logins....

11. Looking for Time Keeping, Time Tracking Software

12. Keeping track of changes


 
Powered by phpBB® Forum Software