Editing a System Stored Procedure

#1

I'm having difficulty editing a stored procedure as described in:

http://www.sqldts.com/default.aspx?6,105,212,0,0

I'm sa, I've checked "Allow modification to system catalogs", yet I still
cannot edit this stored procedure. What am I doing wrong? Thanks. Chuck

#2

A reply in another group said to use Query Analyzer and then use Alter
instead of Create. This worked well -- problem solved.

"CR" <jilesjilesjse@jilesjsilessef> wrote

Quote:

I'm having difficulty editing a stored procedure as described in:

http://www.sqldts.com/default.aspx?6,105,212,0,0

I'm sa, I've checked "Allow modification to system catalogs", yet I still
cannot edit this stored procedure. What am I doing wrong? Thanks. Chuck

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Editing a System Stored Procedure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Editing a System Stored Procedure - 08-01-2003 , 07:49 AM

Re: Editing a System Stored Procedure - 08-01-2003 , 12:22 PM