• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

SUser_Name function in sql server

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?

1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, there is no function to get that information in that scenario

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now