WORKAROUND:
Download LiteSpeed for SQL Server 7.0.4 xpSLS Hotfix for SOL106877 by:
Steps to install patch after being extracted from attached RAR file.
To install this hotfix/patch:
Copy xpSLS.dll from the Binn folder in the installation directory of the SQL instance (Usually, C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008\MSSQL\Binn) to some other location.
Rename the appropriate library file to xpSLS.dll. Review the following for additional information:
| If the server instance is... | Use this library... |
|---|---|
| a 32-bit instance | xpSLS.x32dll |
| a 64-bit instance | xpSLS.x64dll |
In SQL Server Management Studio, run:
dbcc xpsls (free)
In the Binn folder, replace xpSLS.dll with the renamed library.
Repeat steps 3 and 4 for all instances in question.
STATUS:
Enhancement request CR105916 has been fixed in NetVault LiteSpeed for SQL Server version 7.1.
If updating on a cluster environment:
There is no need to failover any instances to install the patch.
On Node A and Node B remove or rename the old xpSLS.dll and run the command DBCC xpsls(free) in the SQL Server Management studio connecting to that particular instance.
Then copy over the new renamed file as per the steps above.
