Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  
Comments
aditya_ingle at 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.
Marcus Kramer at 29-Jan-13 14:03pm
   
Did you bother to read my answer? Install the Management tools for SQL Server 2012 and use them.
aditya_ingle at 29-Jan-13 14:06pm
   
i also tried using Managment tools there also i am not able to create new table.
Marcus Kramer at 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 at 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.

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 412
1 sanket saxena 355
2 Abhinav S 258
3 OriginalGriff 235
4 CPallini 205
0 Sergey Alexandrovich Kryukov 8,704
1 OriginalGriff 5,000
2 Peter Leow 3,839
3 Maciej Los 3,535
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 29 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid