Hi Gerry,
The kill command doesn't allow a local varable as a parameter. You can use dynamic SQL instead.
DECLARE @Cmd VARCHAR(32)
SET @Cmd = 'KILL ' + CAST(@xspId AS varchar(8))
EXEC(@Cmd)
>I'm trying to kill all connections to a certain database. The following command is successful:
>
>KILL 55
>
>I get an error (Line 12: Incorrect syntax near '@xspid') in the following code on the KILL command. Any ideas?
>
>
>declare @xspid smallint
>
>declare killspids cursor local for
> select spid from master.dbo.sysprocesses where dbid = 7
>open killspids
>
>fetch next from killspids into @xspid
>WHILE @@FETCH_STATUS = 0
>
>begin
>
> kill @xspid
> fetch next from killspids into @xspid
>
>end
>deallocate killspids
--sb--