reading the contents of a stored procedure?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yawnmoth - 30 Aug 2008 04:58 GMT

Is there some SQL query you can perform to read the contents of a
stored procedure?

Reply to this Message

Manish Negandhi - 30 Aug 2008 07:52 GMT

> Is there some SQL query you can perform to read the contents of a
> stored procedure?

You can see stored procedure text by executing - sp_helptext
procname

-HTH
Manish Negandhi
[TeamSybase]

Reply to this Message

Carl Kayser - 30 Aug 2008 13:04 GMT

On Aug 30, 8:58 am, yawnmoth <terra1...@yahoo.com> wrote:

> Is there some SQL query you can perform to read the contents of a
> stored procedure?

You can see stored procedure text by executing - sp_helptext
procname

-HTH
Manish Negandhi
[TeamSybase]

Unless "sp_hidetetxt procname" has been used.

Reply to this Message

Carl Kayser - 30 Aug 2008 13:10 GMT

> On Aug 30, 8:58 am, yawnmoth <terra1...@yahoo.com> wrote:
>> Is there some SQL query you can perform to read the contents of a
[quoted text clipped - 8 lines]
>
> Unless "sp_hidetetxt procname" has been used.

And if "select on syscomments.text column" is set to 1 then only the object
owner (and implicitly DBOs) or an SA can read the text - if it is not
hidden.

Reply to this Message

Bret_Halford - 02 Sep 2008 17:25 GMT

> And if "select on syscomments.text column" is set to 1 then only the object
> owner (and implicitly DBOs) or an SA can read the text - if it is not
> hidden.

Although there was a bug in this feature and it really didn't work as
advertised prior
to 12.5.4 ESD #5. CR 449417.

-bret

Reply to this Message

yawnmoth - 15 Oct 2008 19:11 GMT

> On Aug 30, 8:58 am,yawnmoth<terra1...@yahoo.com> wrote:
>
[quoted text clipped - 3 lines]
> You can seestoredproceduretext by executing - sp_helptext
> procname

Reply to this Message

Carl Kayser - 16 Oct 2008 11:16 GMT

On Aug 30, 7:04 am, "Carl Kayser" <kayse...@bls.gov> wrote:

> "Manish Negandhi" <negandhi.man...@gmail.com> wrote in message
>
[quoted text clipped - 6 lines]
> You can seestoredproceduretext by executing - sp_helptext
> procname

All I get when I do that is this:

# Lines of Text
8

I tried "select on syscomments.text column" to see if that was set to
1 and got this:

Incorrect syntax near the keyword 'on'. (severity 15, procedure N/A)

Either of the following should work.

sp_helpconfig 'select on syscomments.text'
go

or

sp_configure 'select on syscomments.text'
go

Reply to this Message