Re: Which users are connected?

From: Brian Lawton (lawton_at_rdacorp.com)
Date: 04/30/03 

Date: Wed, 30 Apr 2003 16:04:46 -0400

...or sp_who2 or from within Enterprise Manager, browse to the Management
folder and look at Current Activity.

--Brian
(Please reply to the news groups only.)

"mike" <mstekol@hotmail.com> wrote in message
news:063f01c30e94$217c78a0$3401280a@phx.gbl...
> try sp_who
>
> Mike
>
> >-----Original Message-----
> >Is there a way to find out which users are connected to a
> >database on SQL Server 7.0 on Windows 2000 Server?
> >
> >Thanks,
> >
> >Anita
> >.
> >

Relevant Pages

  • Re: Basic Table in SQL Server 2005
    ... Could someone tell me how to create a basic table in SQL Server 2005 ... using Enterprise Manager? ... Sabir Barkaat ... right click on the tables folder under the databse you wish the table in ...
    (microsoft.public.sqlserver)
  • Re: SQL Database backup
    ... I don't know about any resources, if you don't have Enterprise Manager you ... backup database, you can specify a location and schedule there. ... at an OSQL script that wasn't working on anything but the C drive. ... and folder? ...
    (microsoft.public.windows.server.sbs)
  • Active Directory + Restricted MMC
    ... restrict/enable the SQL Enterprise Manager appears in the ... snapin's folder? ... Basically I want to restrict all MMC's, ... Enterprise Manager, but there's no option for it in the ...
    (microsoft.public.sqlserver.security)
  • Re: Win 32 folder appears on boot
    ... The system32 folder: ... MVP - Windows Shell/User ... Please reply to the News Groups ... "mike" wrote in message ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Why <Long Text> in decimal field?
    ... It's always a best practice to insert data from Query Analyzer than ... "Mike C." wrote in message ... > When opening a table in Enterprise Manager and starting a new record, ...
    (microsoft.public.sqlserver.server)