Subject Re: [firebird-support] object is in use problems
Author Artur Anjos
A small advice: don't change your metadata. There are no Temporary
Tables in Firebird, so learn to live with this fact. :-)

Why do you create and drop the table? Do you have fields that change a
lot of time? If not, just keep the table there, and delete the data
after you don't need it.

> 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?

Maybe something from IB Expert? I never saw a "SQL Server" user.

Artur Anjos