Get Clients Currently Accessing your DB

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

Transact-SQL (2000)

Get Clients Currently Accessing your DB

Author

Topic

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2005-02-22 : 20:51:26

Good day!

How would you write or is there's a way to write a statement to know what are the clients currently accessing the specified database. Supposed we have to write it on SP with this parameter...

exec sp_ClientsConnectedTo @DatabaseName as varchar(25)

Ex:
exec sp_ClientsConnectedTo 'Northwind'
RESULT SHOULD LOOK LIKE THIS...


ComputerName          IPAddress
--------------------------------------------------
Computer02            192.168.1.2
Computer12            192.168.1.12
Computer17            192.168.1.17
Computer21            192.168.1.21

TNX in advance

Want Philippines to become 1st World COuntry? Go for World War 3...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-02-23 : 08:05:36

Run sp_who

Madhivanan

Failing to plan is Planning to fail

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2005-02-23 : 18:09:35

Tnx madhivanan!

Seems some of the guru here finding hard time to answer my question...

Tnx again...

Want Philippines to become 1st World COuntry? Go for World War 3...

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-02-24 : 09:41:39

some of the guru's here....might be sleeping given your TIMEZONE!!!!!
some of the guru's here may also be busy working at their (paying) day jobs!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources