locked
Change DLL for Extended Stored Procedure? RRS feed

  • Question

  • Is there a way to change the path of the DLL that an Extended Stored Procedure calls without dropping and re-adding it?  Something like "alter extended stored procedure"

    I have been copying the dll into the SQL Binn directory which is not the right way. I'd like to move the DLL and specify the full path like it is supposed to be done.

    However, if I drop and re-add the procedure I will lose the permissions.

    Thanks.



    Saturday, June 25, 2011 6:46 PM

Answers

  •  

    Is there a way to change the name of the DLL that an Extended Stored Procedure calls without dropping and re-adding it

      You will have to drop and recreate the extended store proc using sp_addextendedproc  and sp_dropextendedproc

    and reassign the permission there is no ALTER PROC for an extended proc.



    • Proposed as answer by Naomi N Sunday, June 26, 2011 6:13 AM
    • Marked as answer by Kalman Toth Thursday, June 30, 2011 2:44 AM
    Saturday, June 25, 2011 7:33 PM