The variable in the package will have the one you had hardcoded last time; however, the package will use the value from configuration table if it is implemented correctly.

Sure Jeff I will do that. Thanks.

I guess assign number scores to each fruit and place according to your rule and add all the columns into new column or use CTE and use order by that...

Jeff Moden (7/28/2011)

---

Ah... almost forgot. I got your email. I know you were probably "under the gun" for this task but I don't normally have the time to...

Thanks a lot Jeff. This will help me save a lot of time. Thanks to Lovell as well as I can use his approach for names and other fields. I...

BrainDonor (7/28/2011)

---

Do you mean column encryption? http://msdn.microsoft.com/en-us/library/ms179331(v=SQL.100).aspx

Ghanta (7/27/2011)

---

but the new data should not be any characters... address1 should look like address1 field...

Yeah Lowell thanks. I was checking if someone has something generic for this.

Jeff Moden (7/28/2011)

---

Will...

Thanks a lot Lowell.

I think this trigger does what I am looking for-

create trigger IT1 on Customers

instead of insert

as

begin

insert into encr_Customers (name,SSN)

select name,

...

Thanks a lot for your response. So the user can do insert like this:

Insert into TableName(ID, SSN)

Values('1234', '999-111-2323') without even knowing SSN is encrypted and the Public Key using your...

Elliott Whitlow (7/14/2011)

---

Many times that data is stored using symetric algorithms with the keys only encrypted with asymetric algorithms. The main reason is that symetric algorithms require less costly...

I was asking someone with experience using MS SQL Server Encryption (Asymmetric)... How secured is it? We do not have any policy in place, but moving towards it... Thanks guys...

Yes. Thanks you.

Thanks LutzM for your response. I was just looking for things I should look for in such cases when nothing has changed in the environment or data/indexes/query/parameters.