>Hello,
>
>I need to create a new stored procedure on an MSDE installation. The SQL-DMO object was not installed, I believe. Can I create a stored proc using a VFP client and SPT? What's the best way to handle updates to stored procs on an MSDE installation?
>
>TIA,
>George
Via an SPT, you can send the text for CREATE PROCEDURE in the same way you send SELECT statements. This example is from the BOL:
CREATE PROCEDURE au_info_all
AS
SELECT au_lname, au_fname, title, pub_name
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id
There's ALTER PROCEDURE to make changes, although I am not very familiar with it. We have full SQL Server and usually I go with the management tools for this.