Not able to create table in MS SQL

Category: sql server dotnet

Question

TangaraS on Mon, 02 Jan 2017 08:37:18


I have posted this in other forum and then I followed their advice to upgrade mySQL to 2016 and I should be able to create table with no problem.  This I did 2 months ago but have yet to test out.

Now, I have to do an urgent project and I have to test things out.

But, I am still not able to create the table.

Here's the error message.

This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.DataTools.Interop.IDTTableDesignerFactory.NewTable(Object dsRef, Object pServiceProvider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TableDesignerNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

Please advise what should I do in order for me to use the Ms SQL. Tks.
Microsoft SQL Server Management Studio						11.0.2100.60
Microsoft Data Access Components (MDAC)						6.1.7601.17514
Microsoft MSXML						3.0 4.0 6.0 
Microsoft Internet Explorer						9.11.9600.18537
Microsoft .NET Framework						4.0.30319.42000
Operating System						6.1.7601

Replies

Olaf Helper on Mon, 02 Jan 2017 08:58:41


Hello,

By the error message it seems you are using an older version of SSMS to edit database design of a newer SQL Server Versions. You can get the latest SSMS Version from here: Download SQL Server Management Studio (SSMS)