Determining Object Ownership

one way... to get the owner of the AUTHORS table...
Bruce
SELECT name from sysusers
where uid = OBJECTPROPERTY(OBJECT_ID
('authors'),'OwnerID')

>--Original Message--
>How do I determine the ownership of an object? (i.e.
table)
>.
>
Another way... Open up EM and look at the "owner" column...
Thanks,
Mike C
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:39e401c51f64$0ea67db0$a401280a@.phx.gbl...[vbcol=seagreen]
> another way...
>
> select TABLE_SCHEMA as 'owner'
> from information_schema.tables
> where TABLE_NAME = 'authors'
>
>

Determining Object Ownership

one way... to get the owner of the AUTHORS table...
Bruce
SELECT name from sysusers
where uid = OBJECTPROPERTY(OBJECT_ID
('authors'),'OwnerID')

>--Original Message--
>How do I determine the ownership of an object? (i.e.
table)
>.
>Another way... Open up EM and look at the "owner" column...
Thanks,
Mike C
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:39e401c51f64$0ea67db0$a401280a@.phx.gbl...[vbcol=seagreen]
> another way...
>
> select TABLE_SCHEMA as 'owner'
> from information_schema.tables
> where TABLE_NAME = 'authors'
>
>