Solved

Advice on encrpting some store produces on MS SQL  sql

Posted on 2016-11-19
5
30 Views
Last Modified: 2016-12-01
Any advice if we crypt some store procedures in a db that already has uncryped SP.  Will there be any conflict? Please advice.
0
Comment
Question by:rayluvs
  • 2
  • 2
5 Comments
 
LVL 24

Expert Comment

by:Pawan Kumar
ID: 41894472
explain more what you want to achieve ?
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 41894614
No. The in-built  encryption works per procedure, there is no conflict.
0
 

Author Comment

by:rayluvs
ID: 41894705
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
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 41895162
Encrypted and non-encrypted procedures can exist side by side without any issues.
0
 

Author Comment

by:rayluvs
ID: 41895239
Thanx!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now