Unspecified error (MS Visual Database Tools)

Unspecified error (MS Visual Database Tools)

I got this error when trying to “open table” a Sql server 2008 table from the SSMS 2005. There were numerous reports of this problem, while most of them ended up unanswered. The following is an answer I found from a MS person so I guess it’s likely to be authentic.

The answer is, no, you cannot open a 2008 table using the SSMS 2005.

An alternative is to right click the table, and select

1. “script table as”

2. “select to”

3. “new query editor window”

4. Then a new query window, with the “select” statement populated, will appear. You can then simply click the “execute” button.

This is of course not as good as the one right click and left click of the “open table”, but probably the best available option.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335534

Comments

Hi,

Thank you for reporting this problem. Currently one cannot use OpenTable functionality from SQL Server 2005 SSMS to connect to SQL Server 2008. The only workaround is to use SQL Server 2008 Tools to Design SQL Server 2008 Tables.

Thanks
Karthik

MS SQL Server Manageabilty Team

Posted by Microsoft on 4/17/2008 at 7:14 AM

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

=====

Unspecified error
(MS Visual Database Tools)

——————————
Program Location:

at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.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)