We need to analyse some data in a database which is hosted on remote server. So we planned to copy that data into a new database using ETL and analyze it but we are not allowed to copy that data without permissions. so now we are thinking about using distributed
queries like linked server, analyze the data on remote server and copy that analyzed data in our DB using distribute queries as we can copy that analyzed data.
Any one has any idea of issues that occur if we use linked servers in the products that are shipped beacause to my idea there is o product with linked server concept in it as it will have some issues with permissions and all it seems. So
can any on f you help me out with this please
Thank You so much...
View Complete Post