Transact-SQL Reference

DBCC dllname (FREE)

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

Syntax

DBCC dllname ( FREE )

Arguments

dllname

Is the name of the DLL to release from memory.

Remarks

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.

Result Sets

DBCC dllname (FREE) returns this result set (message) when a valid DLL is specified:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Permissions

DBCC dllname (FREE) permissions default to members of the sysadmin fixed server role or the db_owner fixed database role, and are not transferable.

Examples

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)

See Also

DBCC

Execution Characteristics of Extended Stored Procedures

sp_addextendedproc

sp_dropextendedproc

sp_helpextendedproc

Unloading an Extended Stored Procedure DLL