I run a simple query against a group of databases using the multiple connection feature in SSMS 2008. Nothing too complicated, just trying to see which (if any) databases are annoying me with a particular feature:
sp_msforeachdb 'if databasepropertyex(''?'', ''IsAutoShrink'') = 1 SELECT ''?'''
And I find, rather than a nice, simple set of results showing server & databasename, half a dozen resultsets, and lots of instances of the following message:
Server(Domain\UserID): An error occurred while executing batch. Error message is: This server returned a fewer number of result sets than other responding servers. This may impact the ability to properly merge results.
Yuck. “A fewer number of result sets”? Come on, Microsoft, you can write better English than that, surely? Or, and here’s a radical idea, just merge the results properly in the first place…