At 04:54 PM 22/05/2004 +1200, you wrote:

>OK. I downloaded a couple of commercial packages to evaluate. Il purchase
>one or the other.
>
>What do you sugest as some Freeware that I can distrubute on site ?
>Something for me to use when I am onsite, or remoting in to do basic updates
>and management. no analysis neccesary.

I use IB_SQL unconditionally for all of your following requirements. I
keep a copy on each Windows server I administer - NP at all to use with
PCA, VNC, etc.

>Requirements =
>
>Run and save SQL

Yes. You have two ways to do it: DSQL (for interactive metadata updates
and your executable statements) and Cursor (for dataset queries). Also a
Query Forms tool that you can use for either, esp. useful for those queries
(parameterised or not) that you want to run regularly.

>Run and save Scripts

Yes. And edit, search, them, etc.

>Manage users

Yes -- add, modify (as long as you are SYSDBA, of course).

>Browse Data

Very spiffy browser, shows data, metadata, dependencies, constraints,
triggers, etc., with option to view same for the RDB$ tables. You can
insert, update and delete in the browser, pick off ready-made field lists
for pasting into queries, etc., etc. Most valuable tool in this utility
set: the SQL Monitor and profiler, complete with savable buffer.

Totally free.

/hb