BUG: Sp_certify_removable Db_name, Auto Fails If Case Sensitive

ID: Q157733

The information in this article applies to:

Microsoft SQL Server version 6.5

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


Keywords          : SSrvTran_SQL kbbug6.50 
Version           : 6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 3, 1999