How would I select distinct records from the same table on two different databases?
SELECT DISTINCT col1, col2, ...
FROM
(
  SELECT col1, col2, ... FROM Media_One.dbo.Video
  UNION ALL
  SELECT col1, col2, ... FROM Media_Two.dbo.Video
) AS x;