Hi

Can you please tell me why the following stmt in a sql
server stored procedure breaks my ODBC connection after
calling the stored proc: (the stored proc dies without
any errors)

Here's the offending statement::

execute('select code from ' +@sourceDBpath+'.code_table
where code in (select code from ##tmp_objects)')
if @@rowcount >0
.....

I am trying to check the existence of records in the
code_table that match with records in the ##tmp_objects
table (I create ##tmp_objects as part of the stored proc)