RE: SP set "With Encryption" issues

SSC Guru

Points: 1003863

March 17, 2019 at 12:42 pm

#2024729

My recommendation is to stop using "WITH ENCRYPTION". It does virtually nothing to protect your code. Even software packages like RedGate SQL Compare automatically breaks the encryption so the user can view the code to compare between two databases.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)