The information in this article applies to:
SYMPTOMS
If you apply a service pack on SQL Server 6.5 where QUOTED_IDENTIFIER is
turned on system-wide in the server configuration setting "user options",
the service pack installation scripts will fail and you will see the
following message:
The Sqlole65.out file in the MSSQL\Install directory will show the following message:
The server will be running, but you will not be able to establish a connection to it in SQL Enterprise Manager. If you attempt to connect to the server, you will get the following message:
CAUSEService pack installation scripts expect that the QUOTED_IDENTIFER option is not turned on globally. WORKAROUND
To work around this problem, try either of the following:
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
For information on how to create a stored procedure that can be run to get
a more meaningful display of the @@options value, see the following article
in the Microsoft Knowledge Base:
Q156498 : INF: How to Determine the Current Settings for @@options Additional query words: down upgrade failed backout enabled
Keywords : SSrvInst kbbug6.50 |
Last Reviewed: April 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |