And after an upgrade, 2016 is installed and seems to work as intended 🙂

The fix would seem to be 2016.... it does the same in 2014 and 2012, I''ve moved to Win10, so 2008r2 isn't officially supported. Grr!

I've just seen that but it doesn't actually seem to be an option in 2014... not sure if it's only in 2012 or 2016 :/

This suggests it's in 2016:...

This can be ignored now - but should anyone else have this issue - check your DFS replication! - Multiple replication routes and different timestamps on different servers, ouch. Being...

Thanks for the reply! It's still a problem which I'm just living with tbh, accepting that I have to whizz through a report and change the column headings. Usually it's...

The 'wrapping' seems to work okay:

Obviously they aren't called that but you get the idea - the Proc_Product has about 5-6 parameters, by doing it this...

What I'm saying is there's a proc happily in use in another situation which already has a bunch of parameters, all of which have defaults set already, I'd rather use...

Thanks, I think it was a volume of data issue, I tried with a different query limiting the results set, once I hit about 115,000 rows of data the XML...

Not that I thought it would, however, I've run this against every column in the output (dumping it to a table)

SELECT * from TableName where ColumnName like '%' + '&#xB'...

With such a simple report I decided to make it again, it does have 8 subscriptions against it, which still seem to be there after deleting it and deploying a...

Right, so I *can* use profiler for this, guess what, it's identical in all three cases except for hte ID!

exec sp_executesql N'SELECT * FROM tbla

WHERE ID = @ID',N'@ID int',@ID=4

Running what...

Thanks for the replies guys, on reflection I think a 'meta table' of the collected tables of results might be the way to go, something which can be built up...

Thanks, that looks like it could be useful! I did some searching after I posted, I see red gate do do a sql DATA compare, which I'm currently road testing...

It seems more popular to do this with a CTE now, however, I tend to use a mix of the CTE and FOR XML approach sometimes, here's a FOR XML...

I'm glad you've confirmed that - when I saw the results changed I doubted what I knew about optimize for unknown - I certainly didn't expect that. It seems I...