Extended Stored Procedures no longer work

• Lynn-266641

  SSC-Addicted

  Points: 486

  More actions

  March 26, 2008 at 8:21 am

  #180359

  Hi Everyone,

  Is there a way to list all functions in a DLL? I have a few extended stored procedures that used to work in SQL 2000 and no longer work in SQL 2005. The DLLs still exist but when I execute the procedure, I get a message stating it could not be found in the library. I could not find any documentation on removed functions from SQL 2005 DLLs. Please help.

  These no longer run in 2005:

  xp_printstatements

  xp_displayparamstmt

  xp_displayqueuemesgs

  Thanks,

  Lynn

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  March 26, 2008 at 10:27 am

  #794194

  I think you'll find these were removed from SQL 2005.

  Your option is to write your own proc in the clr to do whatever this proc call did.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Lynn-266641

  SSC-Addicted

  Points: 486

  More actions

  March 26, 2008 at 2:29 pm

  #794342

  I thought so. Thanks.