I am having some problems creating / using an extended stored procedure. (SQL 2005 sp 4) When trying to create a test environment, I knew that an extended procedure was needed which used dll xp_CTNHashProc.dll. So I duly ran :-
EXEC dbo.sp_addextendedproc N'xp_ctnhash', 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\xp_CTNHashProc.dll'
Then ran some code from the live server to prove the extended stored procedure was created correctly. It wasn’t, and returned :-"Cannot load the DLL 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\xp_CTNHashProc.dll', or one of the DLLs it references."
So then I ran sp_helpextendedproc and my extended stored proc was there alongside it was the dll it should reference.
Running DBCC dllname (FREE)
Reports that “DBCC cannot free the DLL "xp_CTNHashProc.dll". The DLL is not loaded”
Does anyone have any ideas as to what is happening and how I can resolve it?
-------------------------------Posting Data Etiquette - Jeff Moden Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx