This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SQL user login activity log

Question
0

Sign in to vote
Hi,

I am using SQL server 2000 and VB application in client computers to access databases. In our application it is possible to create user code for each users in different department. These users acceeing database by running our VB application by ebtering their user code and password

Now I want to get log for

Which user logged in

When Logged out

Idle timeperiod

Active timeperiod

Please help me to find a solution
- Moved by SSISJoostMVP Sunday, March 31, 2013 8:12 AM Not ssis related
Sunday, March 31, 2013 7:52 AM

Answers

0

Sign in to vote
CREATE TABLE LoginTrack table and insert login tracking from the VB application.

Related thread:

http://stackoverflow.com/questions/14575498/sql-create-table-to-store-sql-user-activity

Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
- Proposed as answer by Ramesh Babu Vavilla Monday, April 1, 2013 10:04 AM
- Marked as answer by Fanny Liu Thursday, April 4, 2013 5:40 AM
Sunday, March 31, 2013 2:34 PM
0

Sign in to vote
Hello,

You can use SQL Server Aduit to trace the user logging information from connection pool to the database server. The Audit Login event and Logout event class indicates that a user has successfully logged in or logged out to Microsoft SQL Server.

For more information, please see:Audit Login event and Audit Logout event

Regards,
Fanny Liu

Fanny Liu
TechNet Community Support
- Edited by Fanny Liu Monday, April 1, 2013 10:14 AM
- Marked as answer by Fanny Liu Thursday, April 4, 2013 5:40 AM
Monday, April 1, 2013 10:14 AM

All replies

0

Sign in to vote
CREATE TABLE LoginTrack table and insert login tracking from the VB application.

Related thread:

http://stackoverflow.com/questions/14575498/sql-create-table-to-store-sql-user-activity

Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
- Proposed as answer by Ramesh Babu Vavilla Monday, April 1, 2013 10:04 AM
- Marked as answer by Fanny Liu Thursday, April 4, 2013 5:40 AM
Sunday, March 31, 2013 2:34 PM
0

Sign in to vote
Hello,

You can use SQL Server Aduit to trace the user logging information from connection pool to the database server. The Audit Login event and Logout event class indicates that a user has successfully logged in or logged out to Microsoft SQL Server.

For more information, please see:Audit Login event and Audit Logout event

Regards,
Fanny Liu

Fanny Liu
TechNet Community Support
- Edited by Fanny Liu Monday, April 1, 2013 10:14 AM
- Marked as answer by Fanny Liu Thursday, April 4, 2013 5:40 AM
Monday, April 1, 2013 10:14 AM
0

Sign in to vote

Thanks

Monday, December 16, 2013 6:47 AM