How can I list only My Own Stored procs and not all procs?

[Sina]

Hello all,

I have the following script

Select so.name,sc.name,st.name,sc.length,so.type,sc.type, ownername
FROM syscolumns sc,master..systypes st,sysobjects so
WHERE sc.id in (select id from sysobjects where type ='P')
AND so.type ='p'
AND sc.id = so.id
AND sc.type = st.type
AND sc.type <> 39

Which will list all procs but I would like to see only the ones I have created.

Any idea?

Thanks

 

[MonsterBuck]

I think this is what you are looking for (sql server 2000):

select name, status
from sysobjects
where type = 'P'
and status >= 0