Just an FYI, if you want to alter procedures in production already, you can use the command Alter Procedure, instead of Create Procedure.  Everything else would be as you have it in your scripts.  All it does is change the code of the procedure without touching dependencies or permissions.  I'll change that in these so that you don't have to.

Thanks, :)

Chris Wiebe 
Staff, Data Technologies 
Enron Canada Corp. 
Phone: (403) 974-6929 
Cell: (403) 650-7224 
Pager: (403) 212-9989 
Pager email: chriswiebe@epagenet.net 
Email: Chris.Wiebe@Enron.com 


 -----Original Message-----
From: 	Richey, Cooper  
Sent:	Thursday, October 18, 2001 1:48 PM
To:	Wiebe, Chris
Subject:	development stored procs to prod

can you update the following procs in prod with these scripts while (maintain existing set of permissions?

 << File: sp_poolprice.sql >>  << File: sp2.sql >>  << File: sp3.sql >> 
thx,
cooper