How to delete 6.5 compatible databases in SQL 2005?

• Les Sprott

  Mr or Mrs. 500

  Points: 567

  More actions

  December 14, 2007 at 10:10 am

  #119749

  I have erroneously restored an unneeded 6.5 compatible database to my new SQL 2005 instance. I would like to remove it, but cannot.

  The error message and the links provided below are of no use.

  Has anyone else had this problem? :w00t:

  TITLE: Microsoft SQL Server Management Studio:

  ------------------------------

  Drop failed for Database 'mas500_app'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  6.5 database compatibility level is not supported. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 14, 2007 at 10:52 am

  #760377

  Use DROP DATABASE in a query window

  Tommy

  Follow @sqlscribe

• Les Sprott

  Mr or Mrs. 500

  Points: 567

  More actions

  December 15, 2007 at 12:11 pm

  #760542

  🙂 I kept googling and found a guy who had done the exact same thing and the following corrected the problem:

  --- Reports the current compatibility level of 'MyDBName'

  EXEC sp_dbcmptlevel 'MyDBName';

  GO

  --- Changes it to SQL 2000 - 80

  EXEC sp_dbcmptlevel 'MyDBName', '80';

  GO

  --- Changes it to SQL 2005 - 90

  EXEC sp_dbcmptlevel 'MyDBName', '90';

  GO