?
Solved

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

Posted on 2004-09-01
4
Medium Priority
?
336 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
3 Comments
 
LVL 10

Accepted Solution

by:
imrancs earned 1000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

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
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

807 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