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:http://anmar.eu.org/projects/ctnhashproc/) 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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

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