We encrypt our sql stored procs. One of the main reasons is so that we don't have a support nightmare. For the causal client, they might try to change our stored procs to "improve" them, only to really mess things up. This way we can be relatively sure that what we have in source control for their version is most likely what they have on their database. So when tracking down bugs or issues for clients at least we don't have to worry about if they messed with our stored proc code.

Ben