T-SQL how can I get the name of the domain?

[SteveMe]

I know how to get the server name @@servename

But does anyone know how to get the domain name

Please advise. Thanks

 

[SQLDenis]

host_name()

select host_name(),@@servername

is that what you need

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Jamfool]

select suser_sname()
select SYSTEM_USER

do you mean the logged on user domain?

 

[SQLDenis]

To get domain from user do this

select left(suser_sname(),charindex('\',suser_sname())-1)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SteveMe]

What happens if I can't get the domain name from the suser_name?

 

[SQLDenis]

do you have mixed authentication or windows only?

If I login thru windows authentication suser_sname() will return the domain, if i login as sa or other SQL login then suser_sname() will return sa or the other login only

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

In SQL 2000 you can use this

exec master.dbo.xp_ntsec_enumdomains

However this command isn't available in SQL 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com