Results 1 to 2 of 2

Thread: info

  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: info

    Gan I get the ip address/domain name of the server with a single query?

    How much info can I dig up using something like this
    select @@version
    select @@servername
    sp_helpserver
    sp_help

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    You can rumage through the registry for all of this but I am not aware of any way to get the IP address or Domain name of the server from within SQL Server.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •