UnloadODSDLL Method

SQL-DMO

SQL-DMO

UnloadODSDLL Method

The UnloadODSDLL method frees a dynamic-link library (DLL) loaded into Microsoft® SQL Server™ 2000 memory.

Applies To
SQLServer Object  
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.