Unloading an Extended Stored Procedure DLL
.gif "ms164698.note(zh-tw,SQL.90).gif") 重要事項： |
|---|
| 未來的 Microsoft SQL Server 發行版本將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 Use CLR Integration instead. |
Microsoft SQL Server loads an extended stored procedure DLL as soon as a call is made to one of the functions of the DLL. The DLL remains loaded until the server is shut down or until the system administrator uses the DBCC statement to unload it. For example, this command unloads the xp_hello.dll, allowing the system administrator to copy a newer version of this file to the directory without shutting down the server:
DBCC xp_hello(FREE)
請參閱
其他資源
DBCC dllname (FREE) (Transact-SQL)