The UnloadODSDLL method frees a dynamic-link library (DLL) loaded into Microsoft® SQL Server™ memory.
object.UnloadODSDLL( DLLName )
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list |
DLLName | String identifying an DLL loaded by Open Data Services by name |
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.
HRESULT UnloadODSDLL(
SQLDMO_LPCSTR szDLLName);