Hi, We have production server in which dts job is running,when this job runs there will be blocking and after a few minutes it will fail ,when we try to kill the process ids it will show that it has been killed sucessfully but we still see the bloked process ids,but after the restart of sql server we can't see the bloked process id's ,can any one please reply me why its happening like this. Regards, Hrishi
What steps you are using in that dts package? Enable the package logging to see which query is having such blocking and also you can find out using SP_WHO2. 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.
Then enable the DTS package logging to see more information. 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.
