Lsit of sql object owners

Hi,
What tsql statement do i need to run to get a list of all sql objects'
owner?
ThanksWhat 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...
>> Hi,
>> What tsql statement do i need to run to get a list of all sql objects'
>> owner?
>> Thanks
>|||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...
>> 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
>>
>|||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...
>> 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...
>> Hi,
>> What tsql statement do i need to run to get a list of all sql objects'
>> owner?
>> Thanks
>>
>>
>