For ytical reports, I have to collect data from different databases
resides in different servers to a central location.
So my current approach is ,
I have a table which stores servername and dbname.
Create a SP in central location and dynamically change the servername and
dbname and loads data.
I have to build long dynamic SQL to get data (certain joins are with 3-4
Everything works fine.
Just want know any better approach to handle this ??
Can this be achieved thru DTS (dynamically changing servername/dbname) ??
** One pitfall for my current approach , if anyone of ...