Q

Trying to copy new DLL over old one

I have written an extended stored procedure, and from time to time I make changes to it. I would like to be able to just copy the new DLL on top of the old one, but since it is in use, the OS will not let me. There is a DBCC command to free DLL's, but it does not seem to work. In fact, if I specify an invalid XP name, it still returns with a go response. The only time it returns an error that I can find is when the XP I am trying to release is actually executing. Then it returns a "DBCC cannot free DLL 'XP_Interpolate.dll'. The DLL is in use. DBCC execution completed. If DBCC printed error messages, contact your system administrator." Even when it returns just "DBCC execution completed. If DBCC printed error messages, contact your system administrator." the DLL is not really free, or at least I cannot delete it. Any info would be greatly appreciated.

You can't do this. You HAVE to drop the xp, load your new code, and recreate the XP. There is all kinds of plumbing which has to be done in SQL Server that occurs when you register the XP that you can not simply bypass by dumping new code underneath an already existing procedure call.

 

For More Information

This was first published in September 2003
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close