Jaa


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.

Applies To:

SQLServer Object