I have problem with autocompletion in MSSMS 2008. Every time when I try to write simple 'Id' column MSSMS replace it with 'IDENTITY' (because IDENTITY is first entry that starts on letter I).
I found that entries in autocompletion dropdown aren't sorted correctly, so I have:
entries starting on letter I:
IDENTITY
...
ISNULL
...
ICQNumber
..
Id
Is there any way to change this wrong behaviour to correct one? I mean - force MSSMS 2008 to sort it correctly?