Having issues with a 6.5 DB in 2005

Question

Post reply

Having issues with a 6.5 DB in 2005

mthomas-1136883

Newbie

Points: 3
More actions
July 31, 2009 at 3:24 pm

#207528

I am assigned a project, and I am stumped. The database that I am having issues with is in 6.5 compatible mode in sql2005. But I can not do anything with it. When I right click it, everything is greyed but refresh and rename. I can not even create a new user to the database. It gives an error "6.5 database compatibility level is not supported." This is in Studio Express. I can modify any of the other databases, just not this one.
It is a 2003 server, sql 2005, all updates run. Trying to upgrade an old PC Docs database to the new DM indexer, but I need to modify the database, and I can not.
Any help is appreciated.
Thanks.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

What the "6.5 database compatibility level is not supported" message is telling you?

In a TEST environment you may try this...

use master

go

exec dbo.sp_dbcmptlevel @dbname=N'your65db', @new_cmptlevel=90

go

--- do whatever you have to do, then

use master

go

exec dbo.sp_dbcmptlevel @dbname=N'your65db', @new_cmptlevel=65

go

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

mthomas-1136883 Newbie Points: 3 More actions · Answer 2

Just saw your edit. I will see what happens. Thanks

It tells me exactly that. Management Studio express does not allow me to add a login to a 6.5 db. I guess I have become to reliant on it, but I do not know another way. I no longer have any instances of an older version to modify the 6.5 db. Can you point me in a direction to be able to modify the 6.5 DB? Or at least back it up to I can migrate it to a new setup?

Also, does 2005 Management Studio Express have no ability to do this, or is it just mine?

Thanks for the reply.

mthomas-1136883 Newbie Points: 3 More actions · Answer 3

Hot diggity!! Thank you very much. It was converted properly. Now to scour these forums to fix the other issues.

😀

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 4

Glad it worked out 😉

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Jeff Moden SSC Guru Points: 1004646 More actions · Answer 5

mthomas (7/31/2009)
Hot diggity!! Thank you very much. It was converted properly. Now to scour these forums to fix the other issues.
😀

Heh... you've just gotta love that type of enthusiasm. Welcome aboard!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)