Lsit of sql object owners

Hi,
What tsql statement do i need to run to get a list of all sql objects'
owner?
Thanks
What version of SQL Server are you using?
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
> Hi,
> What tsql statement do i need to run to get a list of all sql objects'
> owner?
> Thanks
>
|||SQL2K sp4
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
> What version of SQL Server are you using?
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
>
|||SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
UNION ALL
SELECT 'View',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
UNION ALL
SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES;
"Mecn" <mecn@.yahoo.com> wrote in message
news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
> SQL2K sp4
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
>
|||It worded,
Thanks a lot
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:632943B2-7BD5-45C3-9C61-E28CA44C5A3D@.microsoft.com...
> SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> UNION ALL
> SELECT 'View',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.VIEWS
> UNION ALL
> SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
> FROM INFORMATION_SCHEMA.ROUTINES;
>
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
>