I need to execute a DTS that would transfer one SQL Server database to another and while the DTS is executing certain queries from my application are timing out when executed, is there a workaround to avoid such timeout? I have adjusted the timeout properties of my connection and command objects but still it is bombing and it would not be good if a certain user waits infinitely for the program to continue.