Message-ID: <7432552.1075841470799.JavaMail.evans@thyme> Date: Thu, 18 Oct 2001 13:12:13 -0700 (PDT) From: chris.wiebe@enron.com To: cooper.richey@enron.com Subject: RE: development stored procs to prod Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Wiebe, Chris X-To: Richey, Cooper X-cc: X-bcc: X-Folder: \ExMerge - Richey, Cooper\infrastructure X-Origin: RICHEY-C X-FileName: cooper richey 6-26-02.PST 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