Bob,

>1. Ship the script as a text file, have the users open Query Analyzer and run it.

Using MSDE at the clients site.

>2. Shipt an exe (this is what we do) that sends the script to the server. This also allows us to encrypt our SP's.

>3. Include the script in the ap, on connect read a db version, and run the script if it doesn't match. (My main concern with this is if I am using 1.5, and you log in with 1.6 and change the DB schema, then my 1.5 will break.)

That's what I was thinking. Anywhere you can point me to for some samples, etc?

Dan