I have several servers linked together which I want to peform the same queries on and bundle into a report. Is there any way I can select sql variables from a linked server ? A simple example would be to get a list of all versions of the servers.. I can do select * from CAPDEV.DATABASE_NAME.dbo.TABLE_NAME but Id like to do select * from CAPPUB.@@version or something similar. Is this possible ? Thankyou.