DBCC dllname (FREE) (T-SQL)

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 (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