I cannot create table in SQL SERVER

Asked

Viewed 1,666 times

0

I have an instance of SQL SERVER installed locally where I am administrator, I can create Databases but I can’t create tables.
Here is a photo of the error that SQL displays.

inserir a descrição da imagem aqui

More Some Details: 

===================================

Erro não especificado
 (MS Visual Database Tools)

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

   at Microsoft.VisualStudio.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.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
sql sql-server
  • 1

    I just made a script attempt and it worked, this error seems to be related to contextmenu to create tables and also views.

  • Draw up your answer to the question then ;)

  • 1

    But I didn’t solve the problem, I only managed to create what I wanted, the problem persists.

  • Okay, so let’s wait for a valid answer

1 answer

0


"When you search too hard you don’t see what’s right in front of you".

It was using Microsoft SQL Server Management Studio Express version 9.**. ****. **, which is suitable for use with instances of SQL SERVER 2005.

Recently I had installed a version of Microsoft SQL Server 2008 Express Edition, but how was managing to create the banks in this instance that starts with 10. *. ****. * through Management Studio was having no problems.

But when I needed to create table structures and views it presented the error due to the fact that this version of Management Studio is incompatible with new features added to SQL SERVER 2008.

With the installation of SQL Server Management Studio Express version 10. **. ****. ** I was able to solve my problem and access the SQL SERVER 2005 instance without any compatibility problem.

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.