Here's some psuedo code of what I'm doing
set @SqlTxt = 'select SomeCol from SomeTable'
select SvrName from syssevers
while SvrName is not null
begin
exec(@SqlTxt) AT [SvrName]
select next SvrName
end
The exec is really executing on a remote server. Where would I create the temp table in this scenario? Inside the exec?
Thanks!
.