Problems with "SELECT USER" - Result always dbo

[roddy]

Hi there,

i've got a problem with the command "SELECT USER". No matter who is logged in and no matter how he is connected (windows authentificatio n or not), the result is always 'dbo'. The same happens with "SELECT USER_NAME()".

Has anyone a hint on what I could have made wrong?

Thanks!

[iburyak]

Try this

[PHP]SELECT SUSER_SNAME()[/PHP]

[roddy]

Thanks a lot! That did the trick.

[iburyak]

It is a bug in Server 2000 that I reported to Microsoft.

Function suser_name() has to return current login user but it returns null instead. It works perfectly on previous versions.

suser_sname() is a work around not many people know of.

[navamnk]

SUSER_NAME is given in SQL 2000 only for backward compatibility

[jooorj]

goood
I want to no how can I find last login for sql server ?

[iburyak]

Select Suser_sname()