Enron email

Algorithmic Indexing

18 Oct 2001, 20:12 UTC

RE: development stored procs to prod

From
Chris Wiebe chris.wiebe@enron.com
To
Cooper Richey
Date
Thu, 18 Oct 2001 13:12:13 -0700 (PDT)
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
Quoted or forwarded from earlier messages
-----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