Last post Nov 09, 2009 08:24 AM by shekhar1983
Nov 09, 2009 12:41 AM|shekhar1983|LINK
Can anyone please solve my problem. When i try to attach the database the following error comes
"The database 'TheBeerHouseVB' cannot be opened because it is version 655. This server supports version 611 and earlier".
i have gone through some blog and come to know that this .mdf has been created in sqlserver 2008. But i have sqlserver2005
can anyone please make a script with data for sqlserver2005 and send my mail id email@example.com.
Or do you have any better solution can you please share with me.
Nov 09, 2009 02:29 AM|Mikesdotnetting|LINK
Why don't you download and install Sql Server Express 2008? It's free.
Nov 09, 2009 02:32 AM|vipuldonga|LINK
for that you have to set Compatible Level of your sql server 2005 usign this you can allso attach 2008 database into 2005 for that you can refer this site they can give solution in the detail please follow his steps.
Nov 09, 2009 05:24 AM|shekhar1983|LINK
Hi Vipul thank you for your reply but TheBeerHouseVB.mdf which having compatibility of 2008 but i am not able to attach so i dont understand how do i execute this code
SET SINGLE_USER TheBeerHouseVB
EXEC sp_dbcmptlevel TheBeerHouseVB,
ALTER DATABASE TheBeerHouseVB
when ever i copied in my data folder in sqlserver in program file and try to execute i database does't exist. i dont understand unless untill i donot attached how do i execute.. or some where i do mistake
which i not following ... can u please help me.
Nov 09, 2009 08:24 AM|shekhar1983|LINK
ya yoou are write. My office is using Sqlserver2005 with licence. so i am not able to install without admin permission. so is there any other way to solve this.
Thank you for your reply