Hi David

I am doing it with SQL authentification as to the linked server like i have said I am very new to sql so I have only setup replication and that worked just perfect for me internally this is why i have gone down this route.

I was recommended to go down the replication route but please tell me if you think i would be better to go down the linked route.

the thing that i dont get is in sql management Studio i can connect to the remote sql server and access all tables etc its just getting the replication to work.

thanks