Sergey,
Thanks for the info, I didn´t know this.
>Keep in mind that there could be more than one table with the same name (but with different owners) in DB.
>SELECT TABLE_SCHEMA FROM database2.INFORMATION_SCHEMA.TABLES
> WHERE table_name = 'tableX'
>
>
>>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?