Domain name

Dear all,
how could I figure out the name of the domain through any statement/function
in Transact-Sql?
Any help or comment would be well appreciate,Enric
SELECT @.@.ServerName
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:EAB3A014-E2A1-4A45-AC35-18574BC7E748@.microsoft.com...
> Dear all,
> how could I figure out the name of the domain through any
> statement/function
> in Transact-Sql?
> Any help or comment would be well appreciate,
>|||Hi
Domain has several different contexts, assuming you want to default windows
domain their is the procedure xp_loginconfig.
John
"Enric" wrote:

> Dear all,
> how could I figure out the name of the domain through any statement/functi
on
> in Transact-Sql?
> Any help or comment would be well appreciate,
>|||Thanks a lot John,
"John Bell" wrote:
> Hi
> Domain has several different contexts, assuming you want to default window
s
> domain their is the procedure xp_loginconfig.
> John
> "Enric" wrote:
>|||Hi Enric
you can try xp_getnetname
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"Enric" wrote:

> Dear all,
> how could I figure out the name of the domain through any statement/functi
on
> in Transact-Sql?
> Any help or comment would be well appreciate,
>|||Thanks Chandra, but it returns just the SQL SERVER name, no domain.
"Chandra" wrote:
> Hi Enric
> you can try xp_getnetname
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.SQLResource.com/
> ---
>
> "Enric" wrote:
>