A quick and easy way to see who is logged in is to run sp_who. Fuller
details are available by interrogating sysprocesses in the master database.
SQLCheck available as a freebie from NetIQ has quite a nice feature for
looking at current activity; this link should get you there.
http://lists.sqlmag.com/cgi-bin3/flo?y=eKi70CJSQq0BRZ0q250As
Particularly for blocking there is also sp_lock.

> -----Original Message-----
> From: Mary Bahrami [SMTP:[Email Address Removed] Sent: Thursday, February 28, 2002 4:25 PM
> To: [Email Address Removed] Subject: OS processes in NT?
>
> All,
>
> We have had some problems with blocking processes, and when I 'killed'
> them
> in EM, it didn't look like they released table locks....I eventually had
> to
> ctl-alt-del to clear it up.
>
> Is there any user process in NT like in oracle on solaris? Like when you
> look in V$session and get the osuser, process in unix?
> How do I see the individual user processes in unix, or is SS too tightly
> integrated into the os to see?
>
> TIA,
> mary
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page