DBCC dllname (FREE) in Microsoft SQL Server

DBCC dllname (FREE)

Unloads the specified extended stored procedure dynamic-link library (DLL) from memory.


DBCC dllname ( FREE )

When an extended stored procedure is executed, the DLL remains loaded by Microsoft® SQL Server™ until the server is shut down. This statement allows a DLL to be unloaded from memory without shutting down SQL Server. Execute sp_helpextendedproc to display the DLL files currently loaded by SQL Server.

This example assumes an extended procedure xp_sample is implemented as Xp_sample.dll and has been executed. It uses the DBCC dllname (FREE) statement to unload the Xp_sample.dll file associated with the xp_sample extended procedure.

DBCC xp_sample (FREE)


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s