Difference between system_user, current_user, and user_name()? 1

[ddiamond]

What is the difference between the functions system_user, current_user and user_name()?

 

[TysonLPrice]

Google is your friend

http://msdn.microsoft.com/en-us/library/aa172599(SQL.80).aspx

 

[jbenson001]

for 2005:

http://msdn.microsoft.com/en-us/library/ms186236(SQL.90).aspx

 

[jbenson001]

for 2008:

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

 

[ddiamond]

Thanks guys. I've looked at all of the links but still cannot tell the difference. The description of each one appears to be the same. Is there really no difference? What I am really looking for is a function that will return the name of the user that logged into the database, regardless of the current context. But all of these functions return the "impersonated" user if a context switch occured.