• 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!

    .