Changing Type of Stored Procedure

Hi guys...
I have some stored procedures which I would like changed from "User" to
"System". Does anyone know the fast way to do this?
Thanks,
ForchI'm curious... why do you need to do this?
"Forch" <forch@.somethere.com> wrote in message
news:u2URsqUAEHA.3400@.tk2msftngp13.phx.gbl...
> Hi guys...
> I have some stored procedures which I would like changed from "User" to
> "System". Does anyone know the fast way to do this?
> Thanks,
> Forch
>|||Because one database has all of these stored procedure that start with"dt_"
and are shown as "system", while the exact duplicate database has the same
"dt_" stored procedures and they are "user" stored procedures.
Cheers,
Forch
"Armando" <blba2k@.yahoo.com> wrote in message
news:ObB6PwUAEHA.448@.TK2MSFTNGP11.phx.gbl...
> I'm curious... why do you need to do this?
> "Forch" <forch@.somethere.com> wrote in message
> news:u2URsqUAEHA.3400@.tk2msftngp13.phx.gbl...
> > Hi guys...
> >
> > I have some stored procedures which I would like changed from "User" to
> > "System". Does anyone know the fast way to do this?
> >
> > Thanks,
> >
> > Forch
> >
> >
>|||Those are the result of someone using the Diagram tool in EM. They're
generated
as system procs. I've never seem them listed as user procs. Personally,
I wouldn't
touch them.
"Forch" <forch@.somethere.com> wrote in message
news:em4kNJVAEHA.3220@.TK2MSFTNGP10.phx.gbl...
> Because one database has all of these stored procedure that start
with"dt_"
> and are shown as "system", while the exact duplicate database has the same
> "dt_" stored procedures and they are "user" stored procedures.
> Cheers,
> Forch
>
> "Armando" <blba2k@.yahoo.com> wrote in message
> news:ObB6PwUAEHA.448@.TK2MSFTNGP11.phx.gbl...
> > I'm curious... why do you need to do this?
> >
> > "Forch" <forch@.somethere.com> wrote in message
> > news:u2URsqUAEHA.3400@.tk2msftngp13.phx.gbl...
> > > Hi guys...
> > >
> > > I have some stored procedures which I would like changed from "User"
to
> > > "System". Does anyone know the fast way to do this?
> > >
> > > Thanks,
> > >
> > > Forch
> > >
> > >
> >
> >
>