To be honest - it doesn't. 🙁 Let's take this sentence:

For binary collations on Unicode data types, the locale is not considered in...

Hmm... don't quite grasp you thought, sorry. Do you want to say that all these numerous BINs just for...

There is no "error demonstration" code, my question is more philosophical and theoretical. But, the closest I...

Yes, I catch the idea now, thanks a lot! If we write select inside the CTE it's NOT automatically mean that outside...

I don't have goal...

Hmmm... Don't shure about sp_change_users_login. Agree to it description (http://msdn.microsoft.com/en-us/library/ms174378.aspx) this SP works with database user, whereas I...

The problem solved! As it turn out the events happen in this sequence:

1. I create XXXuser on COMP

2. I create COMP\XXXuser login on MSSQLSERVER2

3. I remove XXXuser from COMP

4. I...

Already try. 🙂 Alias ZZZ...

And? What this give to me? I already CAN connect to named instance as admin! But I want to connect as non-privileged user...

Thanks for reply, but this is not a case. I just can't add any rights because this all happen on my home computer. Of course, here I am BUILTIN\Administrator in OS(Win...

OK, thanks for detailed answer! I catch your thought concerning "best practice"... Sound sensibly, indeed! Thanks once more for this hint.

Aha... Thanks for confirmation of my apprehensions. I also think this paragraph from course miss nuances...

I give my thanks to all. With you help I completely understood the main idea behaind "magic" term "Tail-log". Thanks once again....

OK, I see the problem. So - I just tell where from my question came.

I just read official course from MS - Course...