devstudy

isql -Usa -P //12.5버전 이상은 생성시 용량 표시를 영문 붙이면 됨 //물리적인 디스크 생성 disk init name=misequ_dev, physname="D:\SYBASE\misequ_dev.dat", vdevno=8, //12.5이상은 생략 가능 //size=512000 alter database misequdb on misequ_dev = 1000(생성된 데이터베이스 용량 확장시) disk init name=misequ_log, physname="D:\SYBASE\misequ..

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..