T-SQL command to log in as a different user? Is there a T-sql command, like the Oracle "Connect" which lets me change the user that I am logged in as?
You can use the EXECUTE AS command:

http://msdn.microsoft.com/en-us/library/ms181362.aspx