18 Oct 2001, 20:12 UTC
RE: development stored procs to prod
- From
- Chris Wiebe chris.wiebe@enron.com
- 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