UnloadODSDLL Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The UnloadODSDLL method frees a dynamic-link library (DLL) loaded into Microsoft SQL Server memory.
Syntax
object.UnloadODSDLL(DLLName)
Parts
object
Expression that evaluates to an object in the Applies To list.DLLName
String that identifies a DLL loaded by Open Data Services by name.
Prototype (C/C++)
HRESULT UnloadODSDLL(
SQLDMO_LPCSTR szDLLName);
Remarks
SQL Server implements a call to a function exported from a DLL as an extended stored procedure. When a SQL Server process calls the extended stored procedure, SQL Server Open Data Services loads the DLL and locates the function entry point. By default, the DLL remains loaded until the SQL Server service shuts down.
Use the UnloadODSDLL method to free a DLL implementing a SQL Server extended stored procedure when required. For example, when a Microsoft Windows operating system loads a DLL, the operating system file implementing the library is opened as shareable, read-only. An attempt to update the file fails. Freeing the library allows installation of a new version of the library.