Installing an extended SP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Installing an extended SP

Hi all! I want to install an extended SP onto my active/passive cluster (namely this one: I read that you need to install it on a ‘shared disk’ in a cluster otherwise it won’t work if the cluster fails over. Would I just need to do something like this, where D: is a drive on the SAN that belongs to the current active node.
USE master
sp_addextendedproc ‘xp_ctnhash’, ‘D:SomePathxp_CTNHashProc.dll’
Also, are there any other things I have to be aware of before installing an extended SP onto a cluster? Thanks! Kristi
I;m not aware of any issues in using these extended SPs in clustered environment at my end. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Can you post the link where you’ve read this? —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

you need to intsall the extended stroed procedure to both of the base nodes to keep it working when failover happens. Thanks N’ Regards