To find Windows Domain Name using TSQL

• Nimesh T Mathews

  Right there with Babe

  Points: 727

  More actions

  February 5, 2008 at 9:27 am

  #123476

  Hi,

  How can i get the windows domain name using a TSQL command.

  Any help will be greatly appreciated.

  Regards

  Nimesh

• floyd99

  Mr or Mrs. 500

  Points: 571

  More actions

  February 5, 2008 at 3:44 pm

  #775363

  well there's an environment variable for it.. so i just did a quick google and found this:

  http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1056858,00.html

  the environment variable you're after is USERDOMAIN

  haven't tested it.. let us know if it works 🙂