Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

Advice on encrpting some store produces on MS SQL sql

Any advice if we crypt some store procedures in a db that already has uncryped SP.  Will there be any conflict? Please advice.
0
rayluvs
Asked:
rayluvs
  • 2
  • 2
1 Solution
 
Pawan KumarDatabase ExpertCommented:
explain more what you want to achieve ?
0
 
QlemoC++ DeveloperCommented:
No. The in-built  encryption works per procedure, there is no conflict.
0
 
rayluvsAuthor Commented:
We have question working in what we want to achieve in EE: crypted queries.

It's just we thought that where the database already has over 100 store procedures which are not encrypted, we wanted to that our few SP saved as encrypted, would not affect the day-to-day use of the database.
0
 
QlemoC++ DeveloperCommented:
Encrypted and non-encrypted procedures can exist side by side without any issues.
0
 
rayluvsAuthor Commented:
Thanx!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now