With DBs in different countries, different servers but same structure, I have created registered server to access them when running certain queries for reports on SSMS. Thus far this is ok. However, I would like to enhance this and have the end users be able to extract the data over Excel.(already able to do this but on individual countries). How can I use MS Excel to extract data from registered servers.
All this is on SSMS 2008 r2.