SELECT HOST_NAME() in a stored procedure called from C++ program is returning spaces

• Tom John-342103

  SSCrazy

  Points: 2694

  More actions

  September 22, 2014 at 2:19 pm

  #150780

  I want to use the HOST_NAME() system variable in a stored procedure to get the name of the machine from which the stored procedure is called. If I execute the stored procedure from SQL Mgmt Studio, it works as expected. The stored procedure returns the name of my workstation.

  When the stored procedure is executed from a C++ program, HOST_NAME() returns spaces. Any idea as to why this would be happening?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 22, 2014 at 3:10 pm

  #1747247

  Check the connection string which the C++ app is using. The host name can be specified in the connection string.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass