Very Computer

by **Bo Hedemark Pederse** » Tue, 08 Feb 2000 04:00:00

How come this doesn't work:

?
I need to kill all connections owned by a specific user, before dropping
him (and his login).

Thanks,
Bo

by **Tibor Karasz** » Tue, 08 Feb 2000 04:00:00

Bo,

--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.

> How come this doesn't work:

> ?
> I need to kill all connections owned by a specific user, before dropping
> him (and his login).

> Thanks,
> Bo

by **Neil Pik** » Tue, 08 Feb 2000 04:00:00

Because it doesn't! Look up the EXEC command

> How come this doesn't work:

> ?
> I need to kill all connections owned by a specific user, before dropping
> him (and his login).

> Thanks,
> Bo

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (412 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.sql-server.co.uk

by **Bo Hedemark Pederse** » Wed, 09 Feb 2000 04:00:00

Short and precisely, thanks!

Very Computer

why not 'KILL @aux'?

why not 'KILL @aux'?

why not 'KILL @aux'?

why not 'KILL @aux'?

why not 'KILL @aux'?