Resolving Server Name in DTS Connection

• Dave Lobas

  Hall of Fame

  Points: 3442

  More actions

  January 16, 2008 at 1:10 pm

  #70699

  How does SQL resolve a DTS connection entered as (local) to the server name? Does it use @@SERVERNAME? Does SQL go to the OS? Or does it do something else?

  How does SQL resolve the opposite situation where the server name is specified in the connection instead of (local)? Would it use DNS in this case?

  Thanks for your help!

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  January 16, 2008 at 2:04 pm

  #768958

  Partial answer for your question.

  @@Servername returns the SQL Server name, more precisely, SQL instance name.