QUESTION POSED ON: 03 September 2003 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.
>
EXPERT RESPONSE
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.
Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
