xp_terminate_process not found

• rob mcnicol

  SSC Eights!

  Points: 834

  More actions

  July 5, 2004 at 4:40 am

  #161667

  hi there,

  i need to kill a process from within a dts package.   I figure the best way to do it is with xp_terminate_process which tested fine on my test server.

  but when i tried to do it on the live server, i found that xp_terminate_process is not there.

  select @@version told me this about the live server:

  t SQL Server  2000 - 8.00.760 (Intel X86)

   Dec 17 2002 14:22:05

   Copyright (c) 1988-2003 Microsoft Corporation

   Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  the dll for this xp is xpstar.dll.   the version on the live server is 80.760.0

  the version of xpstar.dlll on the test server is 80.194.0 (which the msn help says is older)

  i note that xpstar.dll is used by many of the xps.

  any ideas how i get xp_terminate_process onto the live server?

  thx

  rob

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  July 5, 2004 at 5:29 am

  #513274

  Try looking in the Master database through either EM or the object browser in the extended procedures section.  This procedure should be there.

  You may be having 1 or both of the problems below:

  1. You need to ensure that you are calling EXEC master..xp_terminate_process
  2. You don't have permission in production to EXEC this procedure

  Good Luck

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Wayne-153714

  Hall of Fame

  Points: 3536

  More actions

  July 5, 2004 at 7:27 am

  #513293

  If you need to add a new extended sproc to your server, run sp_addextendedproc in the master database.

  Examples

  This example adds the xp_hello extended stored procedure.

  USE masterEXEC sp_addextendedproc xp_hello, 'xp_hello.dll'

  ---

  When in doubt - test, test, test!

  Wayne