Here's the procedure, and don't claim you weren't warned.  Let me also make the following points.  First, I now know that this couldn't violate more rules of stored procedures than...

No, I understood about running it thru the QA debugger.  It doesn't fail there.  In fact, after it has failed in the application, and the user logs out of the...

Remi,

Thanks for responding.  As for using QA, I have, and it runs fine.  In fact, it runs fine most times it executes in my application.  The problem seems, at least...

Farrell,

Thank you so much, although 'easy' is not exactly how I'd characterize the solution.  My first thought was a UDF, but I'm trying to break out of the habit of...

Frank,

You certainly would think so, but it's purchased software, and therefore out of my control.  I intend to raise the issue at our next vendor meeting.

Mattie

I personnally would use in your place a global temporary table (##Temp) which is available to all procs. The problem with the global temp table is that you have to...

I'll definitely take a look at that.  After further digging, we think the truncate table command that was in the timed-out task ran into an incremental backup of the files. ...

The situation you're describing will happen if the following is not true (from BooksOnLine)

In a client/server environment, the client workstation running the debugger must be a member of the...

'Gotcha' is a polite term for what this is.

Part of me hates to ask this, but the part of me that's spent two days on this is desperate.  Apparently I...

Thanks for responding.  I'm not sure how to close the connection, since I don't explicitly create and open one in this routine.  I did create a connection, use it to...

This series might be of interest.

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=113

Mattie

That's an excellent point.  Unfortunately, it's not my design, and changing it is out of my control. 

Mattie

That sounds like what happens when the following is not true

From BOL:

SQL Query Analyzer comes equipped with a Transact-SQL debugger that allows you to control and monitor the...

Thanks again for responding.  As I've mentioned, using a cursor is definitely my option of last resort, but your code will be a HUGE help if it comes to that.

I'm...

Oh well, the answer to your questions about the machine on which the SP is working:

It's configured to handle multi-processing, but it only has one processor at present.

It is standard edition,...