|
Home > Archive > MS SQL Server > February 2006 > Network Monitor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Praetorian Guard 2006-02-06, 7:23 am |
| Hi NG,
#1:
Is there a utility from microsoft that can monitor who is connected to our
Windows 2000 server similar to netwatch.exe from the resource kit but
instead of monitoring the shared folder I would like to know who is
connected to my Oracle, Sqlserver databases without going to enterprise
manager.
#2:
Also I can use net send /user to all users connected to my Sqlserver
database but not on the users connected to my Oracle database. I'd like to
know if there is a utility to send a message to all users connected to our
server regardless of the database server installed.
Thank you in advance.
| |
| Uri Dimant 2006-02-06, 7:23 am |
| 1)
sp_who, sp_who2 'active'
2)
Do you have an Oracle database defined as a linked server?
"Praetorian Guard" < praetorian@gatekeepe
r.com> wrote in message
news:e23KcHwKGHA.2300@TK2MSFTNGP15.phx.gbl...
> Hi NG,
>
> #1:
> Is there a utility from microsoft that can monitor who is connected to our
> Windows 2000 server similar to netwatch.exe from the resource kit but
> instead of monitoring the shared folder I would like to know who is
> connected to my Oracle, Sqlserver databases without going to enterprise
> manager.
>
> #2:
> Also I can use net send /user to all users connected to my Sqlserver
> database but not on the users connected to my Oracle database. I'd like to
> know if there is a utility to send a message to all users connected to our
> server regardless of the database server installed.
>
> Thank you in advance.
>
>
| |
| Praetorian Guard 2006-02-07, 3:23 am |
| I forgot to mention that I want to do it outside query analyzer or
enterprise manager.
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eYkc5TwKGHA.2668@tk2msftngp13.phx.gbl...
> 1)
> sp_who, sp_who2 'active'
>
> 2)
>
> Do you have an Oracle database defined as a linked server?
>
>
>
> "Praetorian Guard" < praetorian@gatekeepe
r.com> wrote in message
> news:e23KcHwKGHA.2300@TK2MSFTNGP15.phx.gbl...
our[color=darkred]
to[color=darkred]
our[color=darkred]
>
>
|
|
|
|
|