can you please let me know more about , why encryption is not the proper solution for this issue..?
You answered this yourself...
as far as I know from all our conversation is that , all our user has to work on the same server , so there is no point to do the single column encryption, because symmetric key and certificate will be there on the same server , so any of us(user) can decrypt that data.
Encryption is pointless if you include the clear text values next to it. The point of encryption is to protect the actual values. If you have them side by side you didn't protect those values. And if you have several people all with the same access encrypting it doesn't do any good because they all have the key.
This is like buying a safe to protect your money. Then you want 1 employee to have access to the safe as a precaution. Then to allow this 1 person access you put the combination on a post-it note on the outside of the safe. You did accomplish locking up the money and the 1 person has access. However, so does everybody else.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/