SELECT s.name As schema_name
     , o.name As table_name
     , c.name As column_name
FROM   sys.objects As o
 INNER
  JOIN sys.columns As c
    ON c.object_id = o.object_id
 INNER
  JOIN sys.types As t
    ON t.system_type_id = c.system_type_id
 INNER
  JOIN sys.schemas As s
    ON s.schema_id = o.schema_id
WHERE  o.is_ms_shipped = 0
AND    t.name = 'uniqueidentifier'