Click here to Skip to main content
14,271,361 members
Rate this:
Please Sign up or sign in to vote.
See more:
In SQLServer 2008,i receive following error ,when I right click on any table in any of the databases on the server, and Edit top 200 Rows That time getting message and also not able to Edit table in design mode.

"Dashes are in the wrong position for GUID parsing. (SQLEditors)"


====================================================================== Dashes are in the wrong position for GUID parsing. (SQLEditors) ------------------------------ Program Location: at System.Guid..ctor(String g) at Microsoft.SqlServer.Management.DataTools.DataServices.DataSourceManager.GetDataSourcesImpl() at Microsoft.SqlServer.Management.Data.DataSourceManager.GetDataSources() at Microsoft.SqlServer.Management.Data.DataSourceManager.GetDataSource(Guid source) at Microsoft.SqlServer.Management.DataTools.DataServices.DataConnection.SetConnectionStrings(String connectionString) at Microsoft.SqlServer.Management.DataTools.DataServices.DataConnection..ctor(DataProvider provider, String connectionString, Boolean encryptedString) at Microsoft.SqlServer.Management.DataTools.DataServices.DataConnectionFactory.CreateDataConnectionImpl(Guid provider, String connectionString, Boolean encryptedString) at Microsoft.SqlServer.Management.Data.DataConnectionFactory.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString) at Microsoft.SqlServer.Management.DataTools.DataServices.DataConnectionManager.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString) at Microsoft.SqlServer.Management.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString, Boolean update) at Microsoft.SqlServer.Management.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString) at Microsoft.SqlServer.Management.DataTools.DataServices.DataConnectionManager.Microsoft.SqlServer.Management.Data.Interop.IVsDataConnectionManager.GetDataConnection(Guid& guidProvider, String bstrConnectionString, Boolean fEncryptedString) 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.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc, String fileName) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options) =============================================
Please Suggest me solution.
Posted
Updated 20-Sep-13 9:11am
v4
Comments
gvprabu 19-Sep-13 11:42am
   
Hi,
Send me the entire error message...any thing you checked in Google :-)
Sergey Alexandrovich Kryukov 20-Sep-13 18:48pm
   
Where is the GUID?
—SA

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Put dashes in correct positions. Want to know the correct format? Run the tool "Create GUID". It should be installed in Visual Studio and is available in the menu "Visual Studio Tools" created in the system Start Menu after Visual Studio installation.

—SA
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100