Hi Martin,

> -----Original Message-----
> But, this isn't required perse. You can create a procedure
> with a full body just fine.

I appreciate it isn't required, I was thinking more in terms of simplifying
the sql script for updating and creating databases.

If I have a product that is already in use and I want to modify an existing
stored procedure in the setup I will have to have a different sql script
when using the same setup program to create a new database.

If I use something like

ALTER OR CREATE PROCEDURE SP_TEST ()
AS
BEGIN
...
END;

Then it shouldn't matter if I am updating an existing db or creating a new
one.

Rgds

Si Carter
TECT Software Ltd
http://www.tectsoft.net/