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

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

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