Thread: Modify Stored Procedure

I am trying to modify a stored procedure, and I'm not being allowed in, along with a message that the text is encrypted. IS this something we are supposed to have access to?

U should be able to modify them yes, but what version are you using?

Version 8. Do you know why I would be locked out? I'm getting a message that the property headertext is not available and that the sp is encrypted.

Thanks

Redo the database creation script and remove the line that says

WITH ENCRYPTION

Thanks Peter!

How would I go about doing that?

Peter,

I don't see WITH ENCRYPTION anywhere in the create database script.

There's information on doing that in our knowledge base