SQL Server Performance Forum – Threads Archive
Dts execution and Hostname
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 ytomail id [email protected] Regards
Prachin
See this KBAhttp://support.microsoft.com/default.aspx/kb/269074 about where package will be running. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>