I have used the following algorithm with success:

1. Create a table called <<name of transaction>>_lock.  Table should have a single integer column in it.  Insert one row in the table ...

Since the table joins are left outter joins you could create a table variable with the full results set definition, insert the main table into it, and update the other columns...

I can think of two solutions.

1) Use profiler to trap the SQL.  Save the output to a table and use a select statement similar to

SELECT textdata from <<tablename>> WHERE textdata like...

The variable @NewClosedDetail is not referenced between the declaration and the IF statement.  Since the value has never been set, it is always NULL in the procedure

I had this happen once using a Unix network drive.  The problem was that the error messages from the server were not making it back to the client because of...