Prev: SQL Server version on DPM 2010
Next: How to compare two dataset?
From: Madhava on 21 Apr 2010 08:31
is there a way we can know whats the windows login accountname using a
command within sql (just like select suser_name() ) , if he is still
accessing the SQL server with a SQL account like 'sa'

any sys table maps this info and stores ?
From: Tibor Karaszi on 21 Apr 2010 11:17
Unfortunately not.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Madhava" <Madhava(a)discussions.microsoft.com> wrote in message
news:9FDC0B11-E9B0-4BC6-891B-9DDA9847A203(a)microsoft.com...
> is there a way we can know whats the windows login accountname using a
> command within sql (just like select suser_name() ) , if he is still
> accessing the SQL server with a SQL account like 'sa'
>
> any sys table maps this info and stores ?

From: jgurgul on 21 Apr 2010 11:29
Hi,

No, the best you would be able to get would be the host name of where the
request is coming from.

if you need to get the windows login details, then you need to be using
windows authentication.

Jon

"Madhava" wrote:

> is there a way we can know whats the windows login accountname using a
> command within sql (just like select suser_name() ) , if he is still
> accessing the SQL server with a SQL account like 'sa'
>
> any sys table maps this info and stores ?
 | 
Pages: 1
Prev: SQL Server version on DPM 2010
Next: How to compare two dataset?