thanks kurt.

lets see

thanks to all of you brother

if i have 3 tables in my 2 different databases each having different number of columns, then I have to create 3 views to combine all of them???? or i...

That is the error which i receives

"All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

"

hi,

yes it works for one tables means it can access data from remote server and combine with currently logged server's table, but when i want to add two tables in...

Hi Bills,

Thanks a lot for your kind suggestions. Look you told me to do this, that one table from server1 union with one table from server 2. It works quite...

Thanks brother its been solved:-)

Thanks Brother it works well 🙂

But now i got another problem. I have made 4 instances on sql server 2008 r2 and i want to connect them remotely means want...

now windows accoount has been accepted. but again one problem when i check the view snapshot agent sataus by right clicking on publication again i see an error here is...

windows account which i used to login to machine??? but its not working in sql server snapshop agent and in its properties. Error is "The process account specified is not...

dear can you tell me please how to do this? i mean how to make the windows account be the member of db_owner?