>>>>>>One more question - why in the UPDATE statement where is
>>>>>>username = lower(@username) ? Why do we use lower is SQL Server is case insensitive ?
>>>>
>>>>He is setting it to lower all over the palace and storing it as lower, because SQL Server IS case SENESITIVE.
>>>>
>>>
>>>No, it's case insensitive. I just tried
>>
>>Wow... major whole in my understanding of MSSQL thank you for checking that!!!!!
>>
>>You may have just saved my a** at some point in the future.
>>
>>I learn something new every day <g>
>>
>>Thanks!
>>
>>It is possible to set the server to be case sensitive, by changing the colation. So maybe that is why he was doing that?
>
>I think you can set case sensitivity by selecting the relevant collation at the column level. A 'CS' means Case Sensitive, 'CI' is Case Insensitive. I don't know if you can do this at a table, database or server level - but if you could it is probably no a good idea.
>Best,
>Viv

I see it at the Server Level but I don't see where to change it.
It can be set under options for the Database
I see it at the Table Level but I don't see where to change it.
And yes you can change it at the Column Level

The earlier settings propagate down to the column level. And the column can be set to use them as a default or a specific value from the look of it.