Hello,

I am currently working on a project where I create temp tables in a
Firebird database, insert large number of records into the tables,
copy records from temp tables to permanent tables, then drop the temp
tables. At the end of the process there is >150000 records inserted.
The problem is I get object is in use errors as shown below when
removing some of the temp tables, although I made sure no other
process can connect to the DB during the entire operation.


ISC ERROR CODE:335544348

ISC ERROR MESSAGE:
no current record for fetch operation
unsuccessful metadata update
object TEMP_ORDERS is in use

STATEMENT:
TIB_DSQL: "<TApplication>.dmOrders.scrCleanup.<TIB_DSQL>."

SQL ERROR CODE:-508

SQL ERROR MESSAGE:
The cursor identified in the update or delete statement is not
positioned on a row.

...

The funny thing is when looking at active users count with IB Expert
there are 2 users shown, (SQL Server) and SYSDBA, where only 1
(SYSDBA) should be shown. My question is what is this (SQL Server)
user, and what process could possibly be connecting to the database
with this username?