Adding an Extended stored procedure

  • 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 :-

    [font="Courier New"]"Cannot load the DLL 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\xp_CTNHashProc.dll', or one of the DLLs it references."[/font]

    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 [font="Courier New"]“DBCC cannot free the DLL "xp_CTNHashProc.dll". The DLL is not loaded”[/font]

    Does anyone have any ideas as to what is happening and how I can resolve it?

    Thanks

    Stuart

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]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

  • A bit of an update.

    I have now found that the reason is one of the servers (where the dll works OK) is 32 bit, the other is 64.

    I can only find one version on line for the 64 bit dll - this unfortunately does not work.

    So my original question should now be:- Where can I get a 64 bit version of the DLL all google searches seem to take me to the same dll.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply