Post reply

Need ActiveX script to identify ServerName

  • May 31, 2006 at 1:09 pm

    #366282

    Anyone have an ActiveX VBScript which will render the name of the Server which SQL Server is running on?

    BT

  • May 31, 2006 at 1:22 pm

    #641029

    There is an extended Stored Procedure

    xp_getnetname that will give you the machine name.

  • May 31, 2006 at 2:18 pm

    #641037

    VBscript: Copy and paste it in the file with extention .vbs Double-click to run.

    Works on Windows XP and should on Windows 2003 Server. Not sure if it will work on Windows 2000 computer

    Set objComputer = CreateObject("Shell.LocalMachine")

    MsgBox(objComputer.MachineName)

    Set objComputer = Nothing

     

    Regards,Yelena Varsha

  • June 1, 2006 at 5:12 pm

    #641323

    Or:

    Set objComputer = CreateObject("WScript.NetWork")

    MsgBox(objComputer.ComputerName)

    Set objComputer = Nothing

     

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

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