Morning

Clunky or not - does the job.

Thanks for your help - I wasted a day trying to get this to work

Much appreciated.

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...