Cannot Display HostName

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi Louis_See1,

quote:
Some of the hostname column is blank when using SP_WHO and SP)WHO2 command.
Anyone could help me on this?

the ones where login is sa?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

The connect string has to include "Workstation ID" parameter in the application.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hi Allen,

quote:
The connect string has to include "Workstation ID" parameter in the application.

äh, which connetion string do you use when running sp_who2 via QA?

Cheers,

Frank

Edited by - a5xo3z1 on 08/12/2003 06:32:38 AM

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 4

It is not connection string in sp_who or sp_who2. The application has to be designed to use the workstation ID in the connection string.

Andy's article explains quite clear.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
It is not connection string in sp_who or sp_who2. The application has to be designed to use the workstation ID in the connection string.

well, yes, I was thinking the other way round

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]