I can not create table in SQL SERVER

Question

I can not create table in SQL SERVER

Navigation

#1 by (0 votes)

0

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

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

asked by anonymous 29.12.2014 / 18:33

1 answer

Read inputstream created in another activity Get content from a page using XMLHttpRequest

score 0 · Accepted Answer

"When we look too much we do not see what's right in front of us."

I 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 I was able to create the banks on that instance starting with 10. *. ****. * through Management Studio was not having any problems.

But when I needed to create tables and views I had the error because this version of Management Studio was 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 normally access the instances that already had SQL SERVER 2005, without any compatibility problems.