This datatype has an interesting twist to it. If you have a database with case-sensitive collation, such as, for example SQL_Latin1_General_CP1_CS_AS then the following line of code will produce error:

declare @v-2 sysName;

This is because in databases with case-sensitive collations the sysname will only be recognized if it is spelled in lower case 🙂

declare @v-2 sysname;

will be parsed just fine regardless of case sensitivity.

Oleg