CODEWITHSUNDEEP
sql-server-2008
user3562155
user3562155

Reputation: 51

SQL management studio create table error

I am having trouble creating a new table, it gives me the error: can anyone help me out, thanks!

TITLE: Microsoft SQL Server Management Studio

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

Here is the detailed log:

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

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.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc, String fileName) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

Upvotes: 0

Views: 3337

Answers (1)

Jcl
Jcl

Reputation: 28272

That's a mismatch between the Management Studio version and the SQL Server version. Check that versions are compatible

Upvotes: 2

Related Questions