How to use Extended store procedure

• Arpit Patel

  Newbie

  Points: 9

  More actions

  July 11, 2006 at 6:49 am

  #114168

  Hi ,

  I want to use Extended store procedure  so please help me if any body have a idea of this. Actually I made one dll in visual basic. and i want to use this dll in this extended sp.I already added sp in list. so when i run it then i got error like :

  Cannot find the function ABC in the library (MY DLL NAME). Reason: 127(The specified procedure could not be found.).

  actually i chk all the thing this dll is in correct path.

   

  so could u help me ???

  Waiting for your reply

  Thanks & Regard

  ARPIT PATEL

  email is : arpitpatel@searchworldwide.biz or arpit_678@yahoo.com

   

   

   

• Ryan Cooper

  SSC Journeyman

  Points: 91

  More actions

  July 12, 2006 at 10:02 am

  #648752

   

  After an extended stored procedure is created, it must be added to SQL Server by using sp_addextendedproc

   

  http://msdn2.microsoft.com/en-us/library/ms188379.aspx