Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leoiser
Starting Member
20 Posts |
 Posted - 2007-12-09 : 21:59:18
|
| Hi, DTS is hanging while execting.This DTS run in every one minute.Hanging once in a month(not every month).We are having 10 servers.Every server having this DTS.I dont know whats the problem.Please help.How to avoid this.Is there any method to stop the DTS if it executes more than 1 minutes.Please help.Thanks in Advance.With Regards,Leo |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-09 : 22:14:23
|
| Maybe blocking, did you check with 'sp_who2 active'? |
 |
|
|
|
|
|
DTS hanging