4

I have a shared hosting. I was happy with it. I was creating new databases on its panel and then I was managing my databases with SQL Server Management Studio. I could add new table by right clicking the database with designer.

Database is: SQL Server 10.0.2531 (SQL Server 2008 SP1 I think)

My SSMS details

Microsoft SQL Server Management Studio          13.0.15500.91
Microsoft Analysis Services Client Tools        13.0.1605.86
Microsoft Data Access Components (MDAC)         10.0.10586.0
Microsoft MSXML                                 3.0 6.0 
Microsoft Internet Explorer                     9.11.10586.0
Microsoft .NET Framework                        4.0.30319.42000
Operating System                                6.3.10586

I have updated my SSMS to 2016. But now, when I right click on my database, there is no "New -> Table menu". The right-click menu is only "Filter, Start Powershell, Report and Refresh"

Now I can create new table by New Query menu (by writing query), but where is my "New -> Table menu"? Is this a security issue ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
oneNiceFriend
  • 6,691
  • 7
  • 29
  • 39
  • 1
    I think that it is just that SQL Server 2008 is too old, so not supported by SSMS 2016 – Mike Jul 05 '16 at 07:08
  • 1
    but why that is not written anywhere? – oneNiceFriend Jul 05 '16 at 07:20
  • Yes I was searching for a reference before posting as an answer. It comes down to supported versions of software. Ssms does support a few back releases but they don't support them all. You have to draw a line in the sand somewhere. 2014, 2012 I would expect support for but beyond that...? – Mike Jul 05 '16 at 07:24
  • 1
    https://www.mssqltips.com/sqlservertip/4062/new-sql-server-management-studio-azure-integration/ – MusicLovingIndianGirl Jul 05 '16 at 11:41
  • 1
    According to [this page](https://msdn.microsoft.com/en-us/library/mt238290.aspx) it is supported: "This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2016), and provides ..." – Damien_The_Unbeliever Jul 05 '16 at 14:32
  • 1
    It is missing for me on a brand new table created in a brand new install of SSMS-2016 for a brand new instance of SSExpress-2016. I vaguely remember permissions/roles having to be explicitly set but I cannot quite recall the exact steps. – samus Jul 05 '16 at 19:50
  • 1
    @Damien_The_Unbeliever: in Microsoft speak they probably are referring to "Mainstream Support End Date", that would make SQL 2012 the earliest supported version – Mike Jul 05 '16 at 22:00
  • @SamusArin OneNiceFriend was able to create a table via script, so it wasn't a permissions issue in that case – Mike Jul 05 '16 at 22:17
  • @Mike - the text I quoted says, **specifically** SQL Server 2008. The next line (not quoted) also says it should work for 2000 and 2005 but some features may not work. – Damien_The_Unbeliever Jul 06 '16 at 05:34
  • What is the compatibility level of the database? – Mike Jul 06 '16 at 08:13

2 Answers2

2

There is a bug reported for this issue

connect.microsoft.com

social.msdn

Mike
  • 1,645
  • 3
  • 13
  • 21
1

In SSMS you can use a SQL script to create a new table because that processing is done on the server. However, SSMS provides the capability to add a table, here the User interface has to be developed to provide the necessary features for each version of SQL Server, this obviously has an overhead. So gradually older versions get dropped.

SSMS for SQL 2012 did not provide support for SQL Server 2005.

Now as Damien_The_Unbeliever points out SSMS for SQL Server 2016 supports all supported versions of SQL Server. But this is for "Mainstream Support End Date", so alas, SQL Server 2012 is the last version that has full UI support.

Still you can have mulitple versions of SSMS installed, just like you may need to keep BIDS as well as Data Tools installed to maintain older verions of SSIS

Mike
  • 1,645
  • 3
  • 13
  • 21