UnloadODSDLL Method (SQL-DMO)

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

Applies To

SQLServer Object

Syntax

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

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.

Prototype (C/C++)

HRESULT UnloadODSDLL(
SQLDMO_LPCSTR szDLLName);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.