Afternoon

Is there any way of returning the query

exec a_linked_server.master.dbo.sp_executesql N'select serverproperty(''productversion'')

to a local variable ?

we do not have MSDTC enabled on the target servers so an 'insert into' on a temporary table won't work