Hi,

In chapter 12 pp.429 step #2 in the Try it Out Creating Tables in the Table Designer - I get the following warning in SSMS while connected to (localdb)\v.11.0.3000 and rightclicking the Tables folder in the PlanetWrox database and choosing New Table:

This backend version is not supported to design database diagrams or tables

In control panel I see that I have SQL Server 2012 express Localdb & 2012Management Objects installed.

The component version of SSMS I am using is as follows:
Microsoft SQL Server Management Studio 10.50.2550.0
Microsoft Analysis Services Client Tools 10.50.2500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9 .11.9600.17728
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601

---------------

In the meantime I have it working by coping the database from the resource folder into the project app_data folder, but wondering why this warning message is happening. Any help appreciated!

Thanks!

Hi there,

It looks like you're using an old version of Management Studio (2008 R2) to create tables in a new version of SQL Server (2012). Try upgrading SSMS to the latest version.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!