Solved

tracking user activities and logon/log off times in sql dbs

Posted on 2004-09-01
4
322 Views
Last Modified: 2012-05-05
I need to track user activities on my ms sql dbs...most importantly, when they log on and log off...and set a auto logoff for inactivity after a period of time...can anyone help me with this...boss says it's urgent and I am 'sql impaired'  :-)
0
Comment
Question by:fabi2004
  • 3
4 Comments
 
LVL 10

Expert Comment

by:imrancs
ID: 11951680
0
 
LVL 10

Accepted Solution

by:
imrancs earned 500 total points
ID: 11951702
0
 
LVL 10

Expert Comment

by:imrancs
ID: 11951851

goto this page

http://www.15seconds.com/issue/020715.htm

and search for "SQL Server Log"
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
TSQL recursive CTE challenge... 8 29
sql 2016 Integration Service connecting to 2012 3 29
sql server query 12 23
query linked sql table field from access 4 18
I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question