Eric M Russell (4/18/2012)

Don't outright dismiss the partitioned view option without giving it a try. In this case it's called a Distributed Partitioned View, because it unionizes multiple tables across...

Just for the record, I used Dynamic SQL with the TableList table of table names. As a very simple example, this looked like:

DECLARE @TableName varchar(500)

DECLARE @curTable CURSOR

DECLARE @sql NVARCHAR(1000)

SET @curTable...

One thing that I have noticed is that I can not use a GROUP BY clause with sp_msforeachtable. This would be very useful for other, related, queries, so perhaps I...

I've not tried it yet, but your suggestion looks perfect, Eugene. It is exactly what I hoped that someone would come up with - I can build a list of...