SQL Server 2005 Displaying Object Owners

SQL Server 2005 Displaying Object Owners

SELECT s.name + '.' + o.name AS ObjectName
-- Display schema owner or overidden owner
, COALESCE(p.name, p2.name) AS OwnerName 
FROM sys.all_objects o
       LEFT OUTER JOIN sys.database_principals p
            ON o.principal_id = p.principal_id
       LEFT OUTER JOIN sys.schemas s
           ON o.schema_id = s.schema_id
       LEFT OUTER JOIN sys.database_principals p2 
           ON s.principal_id = p2.principal_id
WHERE o.type IN ('V', 'P') 
AND s.name NOT IN ('sys', 'INFORMATION_SCHEMA')