How can I get the ownership of a table in another Database ?
Is there a function or Stored Procedure (SP) in SQL Server to get it ?
Reason: Building a SP that must access the table of another Database.
Im in database1

SELECT * database2.dbo.tableX

Usually the value is DBO, but if its diferent how tho get that owner, or the owners for each table?

Thanks in Advance

Peter