select distinct sysobjects.name as SP_name --,*
from syscolumns inner join
sysobjects on syscolumns.id = sysobjects.id
and syscolumns.ID in
(SELECT id FROM sysobjects as a
WHERE OBJECTPROPERTY(id, N'IsTable') = 1) and uid =1
--and sysobjects.name like 'e%' and uid =1
order by SP_name
from syscolumns inner join
sysobjects on syscolumns.id = sysobjects.id
and syscolumns.ID in
(SELECT id FROM sysobjects as a
WHERE OBJECTPROPERTY(id, N'IsTable') = 1) and uid =1
--and sysobjects.name like 'e%' and uid =1
order by SP_name