Post reply

network name with T-SQL

  • February 16, 2006 at 10:21 am

    #168246

    Hi everyone,

    is it possible to know the network name of the computer (user's computer) with T-SQL?

    I want to store this information in a table.

    I'm using sql server 2k

    thanks

    Eric

  • February 16, 2006 at 10:29 am

    #621425

    Hello Eric,

    Please check the system table "sysprocesses". You will get the hostname of the machine.

    Thanks and have a nice day!!!


    Lucky

  • February 16, 2006 at 10:39 am

    #621427

    thanks a lot, works well!

  • February 16, 2006 at 2:43 pm

    #621490

    From BOL: (what's an idea to read it time to time! )

    HOST_NAME

    Returns the workstation name.

    Syntax

    HOST_NAME ( )

    Return Types

    nchar

    _____________
    Code for TallyGenerator

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply