Another option is use "database shootdown"
It helped me lots of time when 'modifying' views.
No connections but server reports that 'object in use'

my 0.02$

Marcin

Martijn Tonies pisze:

> Hello Pepak,
>
>>>> Hmm, strange, as disconnecting all sessions should unload the database,
>>>> unless it's busy with some kind of "sweep" or something, I'm not sure
>>>> what
>>>> it does then.
>>>>
>>>> It would be nice if you could check somehow, if you're the only one.
>>>>
>>>>
>>> Easily done: The Firebird Server is blocked on the firewall so I know no
>>> other computer than mine is connected to it remotely. I can't get local
>>> connections to work on my Vista without using TCP/IP, so presumably
>>> noone is connected through local protocol. "Nestat -an" shows that there
>>> are no TCP/IP connections to Firebird port except for two in TIME_WAIT
>>> state. I will see what happens when these two connections die complete -
>>> maybe I am just too quick in running my application after an update.
>>>
>> Yep. I was too quick. When I let the connections die, the metadata got
>> cleared. Problem solved.
>
> Ah, that's good to know :-)
>
>
> Glad I could help.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>