March 24, 2010 at 2:22 am
Not really a major issue, but rather an annoying one:
when I create a column in the Design window of a table and I type nvarchar(10) in the DataType column, the datatype automatically changes to nvarchar(50). After changing it back to nvarchar(10), it stays like that, so it only happens the first time.
It even changes automatically when I copy-paste the value nvarchar(10) from another column.
Is there a default setting that I'm missing somewhere or is it rather an unusual quirk of SSMS 2005?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 24, 2010 at 11:35 am
Annoying, huh? Doesn't happens to me.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 26, 2010 at 6:34 am
I don't recall ever having that problem. Have you checked to see what build number your management tools are at, may have gotten fixed in the service packs.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply