pmadhavapeddi22 (7/2/2014)
to arrive to the solution, I tried with guest account (because this account generally has downward pointing arrow)so , one option is for sure,
Connect permission has been revoked
after this When I tried to disable the login
ALTER LOGIN test_login disable;
The above statement turned the user with downward pointing arrow in red
So I have selected the option
The associated login has been disabled
Where I went wrong ? or the given answers are correct ?
That`s on the Server Security level, but the question pointed to [the user accounts in my databases], this is in the database security level.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant