Thanks for the info I will talk to Development again.

The weird thing about this issue is there seems to be more idle blocking when the system is less busy. ...

Have you done any index de-fragmentation?

Make sure after the sp_addserver you restart SQL. Also, you might want to do a sp_dropserver to remove the old name.

We had a problem with ODBC and it's use of sp_cursoropen.  This was not fixed until SP1.  I have tested it and it seems to have fixed the issue.  While...