database for SQl 2005

May 11, 2010 at 4:38 AM
Edited May 11, 2010 at 4:39 AM

It will be great if you could release the mdf in SQL 2005 compliant version.

I understand that the tutorial is meant for VS 2010 , but I am using Vs 2008 and have SQL 2005.

Coordinator
May 11, 2010 at 6:54 AM

Yes, this makes sense. Someone else had asked that I just include SQL scripts, would that be sufficient?

May 17, 2010 at 3:16 AM
That would be great to have SQL Scripts.
Coordinator
May 25, 2010 at 11:16 PM

I've uploaded SQL Scripts: http://mvcmusicstore.codeplex.com/SourceControl/changeset/view/9299484ae233#MvcMusicStore-Create.sql

Let me know if you have problems with them - I scripted with SQL 2005 compatibility.

Nov 14, 2010 at 8:46 PM

Errors occured when I excuted the script in MvcMusicStore-Create.sql on SQL Express 2005. I need some help because i use sql server 2005.

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'MvcMusicStore'. No entry found with that name. Make sure that the name is entered correctly.

Msg 3728, Level 16, State 1, Line 1

'FK_Cart_Album' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

Msg 3728, Level 16, State 1, Line 1

'FK__InvoiceLi__Invoi__2F10007B' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

Msg 3728, Level 16, State 1, Line 1

'FK_InvoiceLine_Album' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

Msg 3728, Level 16, State 1, Line 1

'FK__Album__ArtistId__276EDEB3' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors.

Msg 3728, Level 16, State 1, Line 1

'FK_Album_Genre' is not a constraint.

Msg 3727, Level 16, State 0, Line 1

Could not drop constraint. See previous errors

Jul 27, 2011 at 9:58 AM

 

Msg 102, Level 15, State 1, Line 1Incorrect syntax near ''.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Album" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Album" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Cart" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.OrderDetail" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.OrderDetail" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Cart" because it does not exist or you do not have permissions.Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'dbo.Cart', because it does not exist or you do not have permission.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.OrderDetail" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.OrderDetail" because it does not exist or you do not have permissions.Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'dbo.OrderDetail', because it does not exist or you do not have permission.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Album" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Album" because it does not exist or you do not have permissions.Msg 4902, Level 16, State 1, Line 1Cannot find the object "dbo.Album" because it does not exist or you do not have permissions.Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'dbo.Album', because it does not exist or you do not have permission.Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'dbo.Artist', because it does not exist or you do not have permission.Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'dbo.Genre', because it does not exist or you do not have permission.Msg 3701, Level 11, State 5, Line 1

Jul 27, 2011 at 9:58 AM

second run

Msg 102, Level 15, State 1, Line 1Incorrect syntax near ''.Msg 3728, Level 16, State 1, Line 1'FK_Cart_Album' is not a constraint.Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors.Msg 3728, Level 16, State 1, Line 1'FK__InvoiceLi__Invoi__2F10007B' is not a constraint.Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors.Msg 3728, Level 16, State 1, Line 1'FK_InvoiceLine_Album' is not a constraint.Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors.Msg 3728, Level 16, State 1, Line 1'FK__Album__ArtistId__276EDEB3' is not a constraint.Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors.Msg 3728, Level 16, State 1, Line 1'FK_Album_Genre' is not a constraint.Msg 3727, Level 16, State 0, Line 1Could not drop constraint. See previous errors.

Jul 27, 2011 at 10:02 AM

sql server 2008 r2 enterprise

ConnectionStrings also have errors,can't use sql server.but only use sql ce4,shit.