right i have figured out how to encrypt my procedures by doing

alter procedure procedure name with encryption as

bla bla bla

now I have a procedure with a little padlock next to it and the modify is now grayed out.

so my problem now is that I am the owner of this procedure but I cannot modify it because it is now encrypted and grayed out. is there any way round this

thanks