Microsoft KB Archive/157733

= BUG: Sp_certify_removable Db_name, Auto Fails If Case Sensitive =

Article ID: 157733

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q157733



BUG #: 16218 (NT: 6.50)



SYMPTOMS
Sp_certify_removable "db_name", AUTO fails with error 15258 instead of giving ownership of the database and all database objects to the systems administrator (SA) and dropping any user-created database users and any permissions they may have.



CAUSE
When you run sp_certify_removable with the AUTO option, it calls sp_check_removable with the 'Auto' parameter. Inside sp_check_removable, the input parameter is tested with the value 'auto' instead of 'Auto'. This problem does not occur with a case insensitive sort order.



WORKAROUND
To work around this problem, install SQLServer with an insensitive sort order.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5.

Keywords: kbbug KB157733

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.