Free for PREMIUM members
Go Premium for a chance to win a PS4. Enter to Win
SELECT b.name FROM sysobjects a, sysusers b
where a.uid = b.uid and a.name like 'PutYourTableNameHere'
Open in new window
To be blunt, I don't like this capability at all. The ability to do this isn't really talked about a lot in Books Online and I know in the 2005 version there was a lot of confusion when object owner was referenced. When you consider the following, it makes sense: the object owner is, by default, the owner of the schema. If no owner is actually specified for the object, the schema owner is the assumed owner. But you can have an object owner.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.