> As above, how can I tell if a sweep is active at the point I am
> checking the system ?

If running Firebird 1.5 SuperServer, AFAIK you should see a special
connected user called "(SQLServer)" (without quotes) or something like
that. I'm not sure about that though.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com