LinkedServer and pass through kind of security

Hi,

I am not expert on SQL server, i need to be able to access different server from withing sproc,

1. Is Linked Server is the best aproach.

2. If yes then how i set it up that it take all authenticated users of this server to remote, i tried with impersonate but it gives error that NT authority dont hae access etc etc (when i try run a sql that accesses remote server)

3. The reason i need to access remote server is ... one of the that table in my db (logTable) is getting to big it is 10 times the size of rest of the db altogether so i though i move it out not just from same db actully put it on a seprate server. so that all the tasks about main db would become easy etc.

any idea help

Sajjad

1. Read about distributed queries here.

2. The articles on Books Online provide examples. If you get stuck, post the statements you tried and any errors you encountered.

3. Depending on the queries you make on that table, moving it to another server might not be the best approach.

Thanks
Laurentiu