Hi Everybody,
I have a particular DTS job that keeps hanging. It is transferring data between one SQL2000 database and another SQL2000 database and performing lots of manipulation along the way.
If I reboot the server, it works fine.
This makes me think that caching may be a problem and I want to set up watches in SQL Profiler to confirm my theory.
Can anybody suggest other watches that may be of interest?
Thanks