>>>>>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