Rules for Finding Objects

If you do not specify an owner name, and you own an object with the specified name, sp_help reports on that object.

If you do not specify an owner name, and do not own an object of that name, but the database owner does, sp_help reports on the database owner’s object.

If neither you nor the database owner owns an object with the specified name, sp_help reports an error condition, even if an object with that name exists in the database for a different owner. Qualify objects that are owned by database users other than yourself and the database owner with the owner’s name, as shown in Example 4.

If both you and the database owner own objects with the specified name, and you want to access the database owner’s object, specify the name in the format dbo.objectname.