Killing a process through a stroed proc

• Charlottecb

  Hall of Fame

  Points: 3932

  More actions

  March 3, 2004 at 4:45 am

  #161226

  Hi all,

  Can someone help me with this.

  I have the following stored proc which takes a parameter of the process to kill, but it won't compile. If I take out the parameter and hardcode a value it will work. What am I doing wrong.

  Thanks

  CCB

  CREATE PROCEDURE [dbo].[prc004KillProcess]

  (@intSPID smallint)

  AS

  Kill @intSPID

  GO

• Arvind-57714

  SSCrazy

  Points: 2529

  More actions

  March 3, 2004 at 6:15 am

  #496872

  What do you need this for? Can u tell me the background?

  Cheers!

  
  Arvind

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 3, 2004 at 6:24 am

  #496879

  Please avoid cross postings. They make it hard to follow. We should leave it here

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]