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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 683992 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 8/12/2011 2:02:18 PM
Access Restriction Public


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 (

> 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