Thanks for comments so far. Just to clarify, I have around 40-50 databases spread accross different SQL2000/2005 instances. All these instances currently run on HP Blade servers attached to...

Found this article useful as a newbie to encryption methods. A dept in our company has asked for an application to store sensitive information in a SQL2005 database, however they...

Thanks for both suggestions, the Alias suggestion seems to be the quickest and easiest method to solve this issue. I will test this solution out.

Many Thanks

Thanks Carl for your suggestion, I carried out this work at the weekend and followed your suggestion which made complete sense and was all plain sailing. No problems at all. ...