SQL Server Performance

Dts execution and Hostname

Discussion in 'SQL Server DTS-Related Questions' started by prachin1, May 14, 2007.

  1. prachin1 New Member

    Hi,

    I wil explain my query as follows:

    I have job scheduled for dts package. The owner for the job is a valid domain user. In the main dts package there are 10 packages called one after another. When 8th package is being executed it gets spid. Each query executed in the tasks gets that id.

    When i execute SP_who2 i get to see the ids and the hostname associated to it. In any case the hostname has to be server name. But in the case of 8th package the hostname is different. If i am not wrong hostname is the name of the pc from which the query is executed. How is it possbile to have different hostname than the server name.

    Can anyone help in tracing out the mc name?

    thanks in advance.

    kindly reply yto
    mail id prachin1@hotmail.com

    Regards
    Prachin
  2. satya Moderator

Share This Page