use sybsystemprocs go drop proc sp_freedevice go create proc sp_freedevice @devname char(30) = null as declare @showdev bit declare @alloc int if @devname = null select @devname = "%" ,@showdev = 0 else select @showdev = 1 select @alloc = low from master.dbo.spt_values where type = "E" and number = 1 create table #freedev ( name char(30) ,size float ,used float ) insert #freed..