Monitoring database changes & current users? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Monitoring database changes & current users?

Author

Topic

sonnysingh
Starting Member

42 Posts

Posted - 2005-12-28 : 01:41:12

Hi All

I am developing a web site to monitoring activities on SQL SERVER. I
need to display list of user(s) currently logged in and any changes
have been made buy specific user(s). I prefer to find out following
things for what I am stuck at the moment:-

1. Who (user) login currently?
2. what database object(s) are changed at what time and date?
3. What database object(s) are chaged by who(user) and from which PC
(IP address)?

Please help me in this...

Thanks in advance

SqlIndia

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-28 : 01:58:11

You can make use of Profiler to get these informations. Also run sp_who, sp_who2
Refer this also
http://www.mindsdoor.net/SQLAdmin/sp_nrInfo.html

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2005-12-28 : 10:54:00

For 2 & 3 maybe see my answer to:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59572

Kristen

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-12-28 : 13:49:18

SQL Server 2000 or SQL Server 2005? If 2005, you can use the Default trace file and select from the log file using fn_trace_gettable (See post here http://www.sqljunkies.com/WebLog/outerjoin/archive/2005/10/16/17157.aspx . Come to think of it you could mimic this in SQL Server 2000 using the same thing.

Jon
-Like a kidney stone, this too shall pass.

http://www.sqljunkies.com/weblog/outerjoin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources