| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DBCC dllname (FREE) (Transact-SQL) |
DBCC dllname (FREE) unloads the specified extended stored procedure DLL from memory. |
rwestMSFT |
randolphwest |
12/05/2022 |
sql |
t-sql |
reference |
|
|
|
[!INCLUDE SQL Server]
Unloads the specified extended stored procedure DLL from memory.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DBCC <dllname> ( FREE ) [ WITH NO_INFOMSGS ]
The name of the DLL to release from memory.
Suppresses all informational messages.
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.
When a valid DLL is specified, DBCC <dllname> (FREE) returns:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Requires membership in the sysadmin fixed server role or the db_owner fixed database role.
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);