
Identify the Owner of a User Table
If your database is maintained by more than one user and some of those users have rights to create tables, it can be difficult to identify the owner of a given table. The sp_tables stored procedure can help you: sp_tables ‘table1’