p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_server thread: How to Insert the Results of a SP_Help into a temp/local table


Message #1 by "Littleton, Reggie, ISD (x)" <RLittleton484@w...> on Mon, 29 Jan 2001 16:41:08 -0600
select  o.name,user_name(uid) as owner,substring(v.name,5,31) as object_type
into #tmp			
		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

cheers
k

> 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

  Return to Index