sql server connect: When i connect to the sql server 2000 and find the host_id() function it
gives the result * which is terrifice. I never seen this type of host_id() is
'*'. Any body knows why it gives the * result . Please Help for solution. why
the host id is '*'

Some of the older drivers don't send host_id to server. I know for a fact
older SQLClient drivers would not send this.
Also I don't know of any JDBC driver that sends this. However I would
expect to see 0 and not "*".

Possibly you have a host named "*"? Never rule out the obvious. (G)

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

[quoted text, click to view]

Was it host_id() or was it host_name(0 that gave you *? One possibility is
that the client has explicitly set the host name in the connection string to
*. For instance, you can connect to a SQL instance using osql.exe and set -H
to "*" on the command line, and you'll see * returned from host_name() for
that connection.

Linchi

[quoted text, click to view]