Get Current User – Get Logged In User

SELECT SYSTEM_USER http://blog.sqlauthority.com/2007/10/27/sql-server-2005-get-current-user-get-logged-in-user/

Login cannot be assigned to a user without login

Given the following code: USE tempdb ; go CREATE LOGIN SSC_Question WITH PASSWORD = 'SSC' , CHECK_EXPIRATION = OFF , CHE...

How to deal with orphaned user

I copied the whole article from Nelson John torefer. Orphaned user is a common problem in SQL server world.When I was working on internal ...