troubleshooting Question

SUser_Name function in sql server

Avatar of ali_alannah
ali_alannah asked on
Microsoft SQL Server 2008
1 Comment1 Solution544 ViewsLast Modified:
If i use windows authentaction login and write the following
select suser_name()
it comes the SQL Login name "current Windows account login name"
that's good
but if i login to sql server by using SQL Login and i tried
select suser_name()
It shows SQL Login
But in this case how can i get the current Windows account Login . is there another funvction to do that?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros