Recently, SQL Server 2005 has been installed on the computer. It works normally on this computer. Everything is OK.
When connected to the server operation Database, however, you Unspecified error when creating the table:
The details of the error are as follows:
===================================
Unspecified error
(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)
=========================================
checked on the Internet, the original problem was between SQL Server versions: SQL Server 2005 Management Studio could not operate SQL Server 2008, so this error occurred.
The solution is to replace 2005 with 2008.
Read More:
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- SQL Server “login failed for user ‘domain account”. [sqlstate 28000] (error 18456). “Problem solving
- Solve the problem of SQL Server limit 2G memory limit installation
- This version of chromedriver only supports chrome version 92 crawler simulates the problem of Google plug-in version when the browser clicks and reports an error
- SQL 2005 remote connection error (provider: SQL network interface, error: 28 – the server does not support the requested protocol
- The problem of MAC switching JDK version and RN Android JDK version leads to compilation failure. Solve it
- Solution to SQL Server Error: 4064
- SQL Server 2008 login 4064 error solution
- SQL Server SSPI handshake failed Error
- SQL server error 15404 solution
- Java 11.0.11 SQL Server connection error
- SQL Server 2008 18456 error and SA unable to login solution
- install sql server 2016 Error code 0x84B20001
- Solution of error converting data type varchar to datetime in SQL Server
- SQL Server 2005, unable to log in, forget sa password, 15405 error!
- About installing SQL server 0 in Windows 10 20h2 × 84bb0001 is one of the solutions
- 12-web security — error injection based on SQL Server — and, convert, cast
- Prompt SQL server error 15023 solution memo when modifying user mapping
- Reporting Services Catalog Database File Existence” error during installing SQL Server 2008 R2
- Microsoft SQL server, additional database error: error 916 solution