What about blocking and cost threshold for parallelism on the troubled server?
😎

Here is a little food for thought on the subject, sometimes the logic can be made more maintainable and readable by not using pivot but by segmenting it in a...

Have you checked the connection configurations?
😎

Can you post the DDL (create table) script, sample data as an insert statement and the expected results please?
😎

Can you elaborate a little bit further on the problem and the expected output, not entirely clear what you are after?
😎

Quick suggestions, not certain though

IIRC, there was a connect item for this error for 2008 SP1, had to do with a registry key "ConfigurationState"
😎

Almost the same as John pointed out but performs better
😎

CREATE table #TempTable
(
regioncountry varchar(50),
sserver Varchar(50)
)
insert into...

Quick thought, looks like an SSMS error, not an SQL error. Do you have a lot of stuff running/plenty of ram/long time since last restart etc.?
😎