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