Hi,
I have trouble to bring back SQL Server Databases that I backed up/detach from a SQL Server 7
installation.
In SSMS I click Databases, Attach choose the database to attach and click Ok.
SSMS successfully attaches the database but the object explorer shows: 'MyDatabase (6.5
Comaptible)'.
I now cannot expand the database menu and context menu options Script database as, Tasks, Delete and
Properties are disabled.
However I can access the database data by T-SQL.
What options do I have to convert the database to SQL Server version 9 and to use all the SSMS menu
options/functionallity
for that database?
Thanks
Bodo
Alex S - 21 Mar 2008 00:07 GMT
Bodo
You have to backup your sql 7 database and restore it in 2005 express.
> Hi,
> I have trouble to bring back SQL Server Databases that I backed up/detach
[quoted text clipped - 15 lines]
> Thanks
> Bodo