September 8, 2012 at 5:53 pm
hi
i am getting following error while attaching mdf file in my SSMS.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks2012'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any help?
September 9, 2012 at 9:34 pm
You cannot attach to a SQL Server 2012 database from an earlier version of SQL Server. Download the Adventure Works for your particular version of SQL Server from CodePlex.
HTH,
Rob
September 10, 2012 at 7:23 am
September 10, 2012 at 8:03 am
i am attaching 2008r2 version to my sql server 2008r2
September 10, 2012 at 8:14 am
September 10, 2012 at 8:16 am
i found installing from the script file was the easiest for me. i had to go and remove any full text stuff as i dont have full text indexing installed on my dev machine.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply