Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: