You want to edit all of those procedures. For the sake of the life of the system. Do encryption the right way.

However...

You can open keys in a trigger.

You would probably...

You want to normalize your data...

However... there is a way you can do this...

Before I tell you how... know that this type of solution is more ticks in the grand...

Something simple like below might work. I've had issues with one of the tables, not sure if it was sql_modules... but it truncates the procedure in the sys view.

*Wrote on...

• This reply was modified 4 years, 6 months ago by  elric.sims. Reason: reread code, removed a closing paren