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
 General SQL Server Forums
 New to SQL Server Programming
 Need some help

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-05 : 07:22:48
Faisal writes "Hello there,

Hope my mail would find you guys in the best of health and spirit.

Well I am new to sql, and m bascially trying new thing siwth it. I would be very glad if you guys could help me out with one of the issues.

I have set up an SQL 2000 Server, and have made accounts for my friends to use it. What i want to do is keep a check on what and who is doing it. Is there a way I could keep a check on my users in SQL 2000???

I would be very thankful if you tell me how to do it.

Many Thanks,"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-05 : 07:36:22
One of the ways is to run Profiler
Run these also
sp_who
or
sp_who2

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -