sql server new users: select user_name() issue -- sql server new users

You're in the

sql server new users

group:

select user_name() issue

Re: select user_name() issue

SQL
10/25/2005 9:16:00 AM

sql server new users:

Use select suser_sname() instead
------------------------------------------------------------------------------------------
"I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads
to suffering..Defragmentation is the path to the darkside.. DBCC
INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with
you" -- http://sqlservercode.blogspot.com/

select user_name() issue

RCL
10/25/2005 12:05:05 PM

When logged in as a database owner, select user_name() returns "dbo". I am
logged in using NT Authentication so I have to think that I should be able
to grab my real user name from somewhere. Is there another a way to find my
NT log in name in a query and stay logged in as a database owner?

Re: select user_name() issue

RCL
10/25/2005 12:32:31 PM

Works Great! Thanks.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn