Viewing post 1 (of 1 total)
select o.name as owner from sysobjects o with (nolock) inner join sysusers u with (nolock) on o.uid = u.uid
where u.name = 'username'
Hope this helps.
Mark
March 24, 2010 at 10:03 am
#1139031