sql_server thread: How to Insert the Results of a SP_Help into a temp/local table
select o.name,user_name(uid) as owner,substring(v.name,5,31) as object_type
from sysobjects o, master.dbo.spt_values v
where o.xtype = substring(v.name,1,2) and v.type = 'O9T'
order by object_type desc, o.Name asc
select * from #tmp
drop table #tmp
if you want to do a single object then go to the master database and open
the sp_help stored procedure and cut out the code you need
> Can any one help me with this. Im trying to exec sp_help than
> insert the
> results into a temp or local table. Can someone send me a example.
> Thanks Reggie