<pre>
dump tran sybsystemprocs with truncate_only
go

use sybsystemprocs
go

if exists (select * from sysobjects where name = "sp_show" and type = 'P')
   drop proc sp_show
go

create procedure sp_show @param char(12) = NULL
as

-- sp_show.sql: shorthand command to show all objects of type X
-- Author: Todd Boss
-- Change log
-- date		author	purpose
-- 4/16/98	T.Boss	creation

if (@param is NULL)
   select name,type,crdate from sysobjects group by type,name 
else
   select name,"object id"=id,"create date"=crdate from sysobjects 
     where type = upper(@param) order by name
go

if object_id('sp_show') is not null
begin
    print '<<< Created procedure dbo.sp_show >>>'
    grant execute on dbo.sp_show to public
end
else
begin
    print '<<< Failed creating proc dbo.sp_show >>>'
end
go         
