Myles Wakeham wrote:

> Thanks for everyone's input on this. I'm thinking that Sean's suggestion
> may work best for us. I can definitely hard code a version number into a SP
> and have it move with the database and check it against the expectations of
> the client program to make sure the versions match. That'll work fine.
>
>

Basically te same as Sean, but I have the information on a table called
"config", that holds other informations about configuration... one of
the is a records with a strinng called "DATABASE.VERSION".

Every script we have in the first line update the value of that record

Create Table Config (
ConfigID integer PK
Key varchar(40),
Value varchar(255)
);

Something on this line...

hth

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br