dbcc-dllname-free-transact-sql.md

title	DBCC dllname (FREE) (Transact-SQL)
description	DBCC dllname (FREE) (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	07/16/2017
ms.prod	sql
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	dbcc_dllname_(FREE)_TSQL dllname dbcc dllname (FREE) FREE dbcc_dllname(FREE)_TSQL FREE_TSQL dllname_TSQL dbcc dllname(FREE)
helpviewer_keywords	DLL unloading [SQL Server] DBCC dllname (FREE) freeing DLLs unloading DLLs
dev_langs	TSQL

DBCC dllname (FREE) (Transact-SQL)

[!INCLUDE SQL Server] Unloads the specified extended stored procedure DLL from memory.

Transact-SQL Syntax Conventions

Syntax

DBCC <dllname> ( FREE ) [ WITH NO_INFOMSGS ]  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

<dllname>
Is the name of the DLL to release from memory.

WITH NO_INFOMSGS
Suppresses all informational messages.

Remarks

When an extended stored procedure is executed, the DLL remains loaded by the instance of [!INCLUDEssNoVersion] until the server is shut down. This statement allows for a DLL to be unloaded from memory without shutting down [!INCLUDEssNoVersion]. To display the DLL files currently loaded by [!INCLUDEssNoVersion], execute sp_helpextendedproc

Result Sets

When a valid DLL is specified, DBCC dllname (FREE) returns:

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

Permissions

Requires membership in the sysadmin fixed server role or the db_owner fixed database role.

Examples

The following example assumes that xp_sample is implemented as xp_sample.dll and has been executed. DBCC <dllname> (FREE) unloads the xp_sample.dll file associated with the xp_sample extended procedure.

DBCC xp_sample (FREE);  

See Also

DBCC (Transact-SQL)
Execution Characteristics of Extended Stored Procedures
sp_addextendedproc (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
sp_helpextendedproc (Transact-SQL)
Unloading an Extended Stored Procedure DLL