"Praetorian Guard" <praetor***@gatekeeper.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.
>
>

"Uri Dimant" <u***@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" <praetor***@gatekeeper.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.
> >
> >
>
>