kill user connections

can someone point me to a good site / article on how to go abt checking for
current user connections and kill these connections,
using Enterprise Mge & T-SQL.
try searching Microsoft, didn't find what I am looking for.
tksTry BooksOnLine. Specifically you might want to look at sp_who and KILL
commands.
Andrew J. Kelly SQL MVP
"pk" <pk@.> wrote in message news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> can someone point me to a good site / article on how to go abt checking
for
> current user connections and kill these connections,
> using Enterprise Mge & T-SQL.
> try searching Microsoft, didn't find what I am looking for.
>
> tks
>|||Hi,
IN Query Analyzer
Execute
sp_who (To get all the connected process)
Kill <Process id> (to kill a process)
Enterprise manager
1. Expand the Management option
2. Expand - CUrrent Activity
3.Click the process info - this will show all process connected
4. Doule click the process to get the statement running (Use DBCC
INPUTBUFFER(process id) in Query Anlyzer
5. Right click and kill (if you need to kill the process)
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O42p##tEEHA.696@.TK2MSFTNGP12.phx.gbl...
> Try BooksOnLine. Specifically you might want to look at sp_who and KILL
> commands.
> --
> Andrew J. Kelly SQL MVP
>
> "pk" <pk@.> wrote in message news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> for
>|||tks.
i also found this, although it uses a script,
http://www.sqlservercentral.com/scr...ibutions/30.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:eToleOuEEHA.2308@.tk2msftngp13.phx.gbl...
> Hi,
> IN Query Analyzer
> Execute
> sp_who (To get all the connected process)
> Kill <Process id> (to kill a process)
> Enterprise manager
> 1. Expand the Management option
> 2. Expand - CUrrent Activity
> 3.Click the process info - this will show all process connected
> 4. Doule click the process to get the statement running (Use DBCC
> INPUTBUFFER(process id) in Query Anlyzer
> 5. Right click and kill (if you need to kill the process)
> Thanks
> Hari
> MCDBA
>
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:O42p##tEEHA.696@.TK2MSFTNGP12.phx.gbl...
news:e#XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
checking
>|||Also Tibor Karaszi has a stored procedure that I always use.. It allows you
to kill all of the connections on a particular database... It can be found
under the procedures section of his web site www.dbmaint.com
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pk" <pk@.> wrote in message news:e%23XJeQtEEHA.3576@.tk2msftngp13.phx.gbl...
> can someone point me to a good site / article on how to go abt checking
for
> current user connections and kill these connections,
> using Enterprise Mge & T-SQL.
> try searching Microsoft, didn't find what I am looking for.
>
> tks
>