Amigos estoy tratanto de atachar una base de datos que tengo en sql2005
developers hacia sql2005 Express con este comando:
USE [master]
GO
CREATE DATABASE [C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf]
ON
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data.mdf' ),
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data_log.LDF' )
FOR ATTACH
GO
if not exists (select name from master.sys.databases sd where name =
N'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [C:\Documents and
Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf].dbo.sp_changedbowner
@loginame=N'sa', @map=false
GO
Pero me muestra este mensaje de Error:
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'.
CREATE DATABASE is aborted.
Msg 950, Level 20, State 1, Line 1
Database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
cannot be upgraded because its non-release version (600) is not
supported by this version of SQL Server. You cannot open a database that
is incompatible with this version of sqlservr.exe. You must re-create
the database.
Como puedo hacer para solucionar este tipo de Error
Gracias
Developers - Dany Acosta
Leer las respuestas