Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
711 views
in Technique[技术] by (71.8m points)

database - "Create new table" is not visible on SSMS 2016 for SQL Server 2008

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 ?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

There is a bug reported for this issue

connect.microsoft.com

social.msdn


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...