Error from SSMS Table Designer when current locale doesn't use single hyphen ("-") as negative symbol

Error from SSMS Table Designer when current locale doesn't use single hyphen ("-") as negative symbol by Jack Tripper

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	683992
Opened:	8/12/2011 2:02:18 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

If the current locale uses anything other than a single hyphen-minus (U+002D) character, the table designer will be unable to design a table, giving various errors.

Examples of negative sign symbols that cause SSMS to crash:

-- (U+002D U+002D two hyphen-minus characters)
‐ (U+2010 Hyphen)
– (U+2013 En Dash)

From LOCALE_SNEGATIVESIGN documentation in MSDN (http://msdn.microsoft.com/en-us/library/dd373865(v=vs.85).aspx):

> String value for the negative sign, for example, "-" for the
> English (United States) locale. The maximum number of
> characters allowed for this string is five, including a
> terminating null character.

Errors generated:

1. Invalid prefix or suffix characters (MS Visual Database Tools)

2. Internal Error, invalid pane configuration. (MS Visual Database Tools)

3. This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

Microsoft SQL Server Management Studio version: 10.50.1617.0

Details (expand)

English

SQL Server 2008 SP1

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Professional (SP1)

US English

1. Click Start
2. Select Control Panel
3. Search "Region"
4. Select "Region and Language"
5. Click "Additional Settings"
6. Under "Negative sign symbol" enter "--" (i.e. two hyphen-minus characters)
7. Click Apply
8. Load SQL Server Management Studio
9. Connect to a server, expand a database, expand Tables
10. Right-click any table and click "Design"

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

Internal Error, invalid pane configuration. (MS Visual Database Tools)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.DataTools.Interop.IDTTableDesignerFactory.EditTable(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.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)

Other stack traces snipped due to character limitation

No error.

X64

0 attachments

Hello,

Thanks for reporting this issue. We triaged this along with the other bugs for our next major release, but unfortunately it did not meet the bar for fixing. I'm resolving this bug as won't fix for now. Please feel free to get in touch with me if you have any concerns.

Thanks,
Prashant Choudhari
(prashant.choudhari@microsoft.com)