dupl2

DECLARE @sql VARCHAR(8000)
SET @sql = ''

SELECT @sql = @sql +
    (CASE WHEN @sql = '' THEN '' ELSE ' UNION ALL ' END) +
    'SELECT ''' + o.name + ''' AS table_name, ORDERID, INTERNTIMESTAMP, COUNT(*) AS cnt ' +
    'FROM ' + o.name + ' GROUP BY ORDERID, INTERNTIMESTAMP HAVING COUNT(*) > 1'
FROM sysobjects o
JOIN syscolumns c1 ON c1.id = o.id AND LOWER(c1.name) = 'orderid'
JOIN syscolumns c2 ON c2.id = o.id AND LOWER(c2.name) = 'interntimestamp'
WHERE o.type = 'U'
  AND o.uid = USER_ID()
ORDER BY o.name

EXEC (@sql)