Finally i managed to Secure the data by Implementing Encryption to the tables. i.e. Adding Encryption keys and certificates to the Columns. now as long as the users don't know...

Hi again,im still strugling with the following initial problem.what is worse is that all peolple with admin account can run the script fine but when running with ur normal user...

Hi Guys thanks for the advice,i think i will have to hide the data in a temp db as people never open that database and work with it from there...

we are using x86 and the reason we wanted to link the servers was to create stored procedures and create jobs that will run at night to update sql table...