|
Home > Archive > MS SQL Server > November 2005 > SQLServer 2005: Deleting Attached 6.5 Databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQLServer 2005: Deleting Attached 6.5 Databases
|
|
| alaskanrogue (Marc George) 2005-11-22, 9:23 am |
| I attempted to attach two 6.5 databases which had been attached to a
SQLServer 2000. An error was thrown because of the compatibility issues but
the dbs are still displayed in the SQLServer 2005 Management Studio under
databases with (6.5 Compatible) behind their names. Nothing else is in tree
branches beneath them like a normal db.
If I try to delete them, nothing happens. If I try try anything else, error
messages siting the compatibility issues appear. The server has locks on the
files.
How do I delete them so I can import them instead?
TIA
Marc
| |
| Tibor Karaszi 2005-11-23, 9:23 am |
| SSMS cannot handle database in 60 or 65 compatibility mode, so it will only display them. You can
change the compatibility level for the database using sp_dbcmptlevel. You can also drop the database
using DROP DATABASE. Note that if you change compat level, you will want to test that the
application work against that higher level.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"alaskanrogue (Marc George)" < alaskanrogueMarcGeor
ge@discussions.microsoft.com> wrote in message
news:C4195D5C-7202-4E69-907C- 0BD71DA21214@microso
ft.com...
>I attempted to attach two 6.5 databases which had been attached to a
> SQLServer 2000. An error was thrown because of the compatibility issues but
> the dbs are still displayed in the SQLServer 2005 Management Studio under
> databases with (6.5 Compatible) behind their names. Nothing else is in tree
> branches beneath them like a normal db.
>
> If I try to delete them, nothing happens. If I try try anything else, error
> messages siting the compatibility issues appear. The server has locks on the
> files.
>
> How do I delete them so I can import them instead?
>
> TIA
> Marc
|
|
|
|
|