I beleive there was an article in FoxTalk a few months ago about some of this.

>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