Re: can i force disconnection from a stored proc ?
From: Johan Koopmans (koopmans.johan_at_hccnet.nl)
Date: 11/19/04
- Next message: GYK: "Re: looking for help to parse in t-sql"
- Previous message: michelle: "Re: FORCE DB Corruption"
- In reply to: Hernán Castelo: "can i force disconnection from a stored proc ?"
- Next in thread: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Reply: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Reply: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 20:39:17 +0100
Yes, it is possible with the Kill Spid command
Execute sp_who to get a report on valid SPID values. Use @@SPID to display
the value for the current session.
This example shows how to terminate SPID 10.
KILL 10
"Hernán Castelo" <bajopalabra@hotmail.com> schreef in bericht
news:OZZ$grmzEHA.2012@TK2MSFTNGP15.phx.gbl...
> inside a stored proc
> that validates the user,
> can i force to disconnect ?
>
> --
> atte,
> Hernán Castelo
> SGA - UTN - FRBA
>
>
- Next message: GYK: "Re: looking for help to parse in t-sql"
- Previous message: michelle: "Re: FORCE DB Corruption"
- In reply to: Hernán Castelo: "can i force disconnection from a stored proc ?"
- Next in thread: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Reply: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Reply: Adam Machanic: "Re: can i force disconnection from a stored proc ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
