Problem solve Get help with specific problems with your technologies, process and projects.

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 last published in September 2003

Dig Deeper on Microsoft SQL Server Installation

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.