January 23, 2007 at 2:21 am
SQL SERVER LOGIN ACTIVITY TRACING
I having an application which connects to the SQL server 2000 as login name SUPERVISOR_SQL and GUEST.
I want to store the information such as Date, login time, logout time etc in a seperate table.
Sysprocess (system table) is storing these information temporarly whenver the user login.
I cannot create trigger on this table because it is a system table.
Thanks in advance & waiting for the reply
Philkos
Philip
January 26, 2007 at 8:00 am
This was removed by the editor as SPAM
January 30, 2007 at 8:10 am
do u want to track only those 2 users or u want to track all the user connections. if so u can enable audit to track all user connections. if u want to track only the 2 users then we have to do something only with the sysprocesses table w/o having to write a trigger.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 30, 2007 at 10:15 pm
Hi Sugesh
Many users may connect to the Sql Server, But i want to trace only these two : SUPERVISOR_SQL and GUEST
Philip
January 31, 2007 at 5:37 am
I have found a way out for this but it looks little complicated to do it. this is as follows.
1. create a table that has all columns for your need
2. create a procedure as per your requirement of selecting from sysprocesses table(for users SUPERVISOR_SQL and GUEST)
3. create a cmd file thats the following osql /E -Q "exec proc_name"
4. then create a VB script that will run ur cmd file
5. then create a windows service that runs this vb script
by this way u ensure that u will that ur req is always met. if u still have any doubts mail me @ sugeshkr@gmail.com
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply