Home Dashboard Directory Help

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


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

Sign in
to vote
Type: Bug
ID: 683992
Opened: 8/12/2011 2:02:18 PM
Access Restriction: Public
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

Sign in to post a comment.
Posted by Microsoft on 10/14/2011 at 2:17 AM

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.

Prashant Choudhari
Sign in to post a workaround.
Posted by Jack Tripper on 8/18/2011 at 6:23 AM
From the Control Panel, revert the locale formatting settings to "English (United States)".

Or specifically revert just the "Negative sign symbol" back to a single hyphen-minus character (i.e. "-")