[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 79
  • 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
 
QlemoDeveloperCommented:
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
 
QlemoDeveloperCommented:
Encrypted and non-encrypted procedures can exist side by side without any issues.
0
 
rayluvsAuthor Commented:
Thanx!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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