>Hi Mike,
>
>No, not my clients.. I wanted a mechanism to update the stored procedures on sight. I was trying to use SPT and had a problem with some of the comments I had in the inside the store procedure that started with "--". I removed the comments and everything worked fine.
>
>But your comment raises another question. How would you update an MSDE database installed at a client site? Can you legally install the Query Analyzer or Enterprise Manager? Or would you build your own interface to the SQL-DMO object? Or... ?

I've written code that uses the dmo com object to script all the SP's to a text file. Then, I have an program that connects to the server requesting the DSN and it sends the contents of the text file. Basicllay I read the text file line by line untill I get to the GO... then I send the text with SQL, and continue parsing. I build this program and the text file into a file named DBUpDATE.EXE and ship it to the customers. All they have to do is double click it to update the stored procedures. We also encrypt the stored procs so this allows us to update them without shipping the text to the customers.

BOb