The ownership of the following objects can be transferred from one owner to another. The ownership of objects not listed below cannot be changed.
Objects for which the ownership can be changed explicitly:
User tables
Proxy tables
Views
Stored procedures
User-defined functions
Defaults
Rules
User-defined datatypes
Encryption keys
Dependent objects for which the ownership cannot be changed explicitly. These objects are transferred implicitly when the ownership is the same as the explicitly transferred object:
Triggers
The ownership of a dbo-owned trigger cannot be altered if the trigger was created for a non-dbo-owned table/view.
Declarative objects that are defined during the table/view creation
Defaults
Decrypt_defaults
Check constraints
Reference constraints
Partition conditions
Computed columns
