not able to add table using visual studio 2010 with sql server 2012

Question

0.00/5 (No votes)

See more:

VS2010

i am not able to add table to my database. i shifted to windows 8 & install sql server 2012 express but i am not able to edit my database from sql server 2008. every time i get error "this server version is not supported. only servers up to 2008 are supported".

Posted 29-Jan-13 7:35am

mryeti

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2013-01-29T07:48:00

Solution 1

Your answer is in the error message. IN order to edit a SQL Server 2012 instance of any kind you have to use SQL Server 2012 tools. Just download the tools from here[^] and use those instead.

Posted 29-Jan-13 7:48am

fjdiewornncalwe

Comments

mryeti 29-Jan-13 13:55pm

but i am using sql server 2012 ? i create a script in sql server 2008 and run it in sql server 2012 i am able to create all the tables & procedure but i am not able to add new table to it.

fjdiewornncalwe 29-Jan-13 14:03pm

Did you bother to read my answer? Install the Management tools for SQL Server 2012 and use them.

mryeti 29-Jan-13 14:06pm

i also tried using Managment tools there also i am not able to create new table.

fjdiewornncalwe 29-Jan-13 14:09pm

Use the "Improve Question" widget to update your question with the CREATE TABLE script you are attempting to use and we'll see if there is something in the syntax that requires updating to make this work.

Mike Meinz 29-Jan-13 15:05pm

Look in this folder:
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio
and make sure that the program SSMS.EXE is at least Product Version 11.0.3000. If it is not, then you are running an old version of SQL Server Management Studio. Also, make sure that this is the SSMS.EXE that you are running when you click on a shortcut link.