Does the table TABLE_MAX_MASTER have any indexes?

If not, based on the manner of access, I would suggest that clustered index on the TABLE_NAME column would seem appropriate.

An index is important...

Cheers Ian - it's a very useful little SP.

I am also finding it useful in detecting questionable queries - where the indexes for the tables have been planned out, but...