471,108 Members | 1,639 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Text for Stored Procedure

Hi All,

Can anybody let me know how to find out the text for the encrypted stored procedures?
Have tried for SP_HELPTEXT, syscomments and information_schema.routines but got only text for unencrypted stored procedures only.
Help will be highly appreciated.

Thanks,
Ruchir
Jan 15 '07 #1
1 1030
almaz
168 Expert 100+
The term "encrypted" as it is applied to stored procedures means that the text of those stored procedures cannot be viewed. So there is no way to look at the text of encrypted SP.
Jan 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by honcho | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.