Share via

"Unspecified error" when trying to create a table from hostgator database

ean ostman 96 Reputation points
2020-09-20T22:52:38.203+00:00

Hi I am very new to this stuff. When I try to create a table in sql server management it gives me this error everytime: 

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

Unspecified error
 (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)

I have tried everything and I cant get it to work and I am using a database from hostgator. any solution?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

ean ostman 96 Reputation points
2020-09-22T00:34:39.533+00:00

nevermind I figured it out

Was this answer helpful?

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator
    2020-09-21T21:59:58.913+00:00

    That's a very helpful error indeed. Exactly at which point do you get this?

    You could try to repair the SSMS installation. Or uninstall and reinstall. Which version of SSMS do you have

    The good news is that you have to use the UI. You can use the CREATE TABLE statement directly in the query. While a UI may be helpful for you as a beginner, using statements is the best in the long run, so you could just as well starting learning now.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.