/*#ifndef NBDBCNFG_SQL_HEADER
**#define NBDBCNFG_SQL_HEADER
**static char SCCS_ID[] = @(#) vobadm  2000/06/28 02:08:58   nbdbcnfg.sql \main\callpilot2.0\1 ~
** vobadm  2000/06/28 02:08:58   nbdbcnfg.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
** vobadm  2000/06/28 02:08:57   nbdbcnfg.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
**#endif
*/
/* create threshold proc for log. */

use sybsystemprocs
go

if  exists (select 1
		from sysobjects
		where sysstat & 7 = 4
		and name like "sp_dbothreshold")
BEGIN
	drop proc sp_dbothreshold
END
go
 
create procedure sp_dbothreshold  @dbname varchar(30), @segmentname varchar(30),
				  @free_space int, @status int
as
	dump transaction @dbname with truncate_only
go


/* Modify the Database configuration parameters */

use master
go

/*
 * Remove the master and sysprocsdev from the default device pool
 */
sp_diskdefault master, defaultoff
go
sp_diskdefault sysprocsdev, defaultoff
go

/*
 * Allocate 16 MB of memory to database. The value below is in the unit of 2K per
 *	page.
 */
sp_configure "total memory", 8192
go

sp_configure "number of devices", 50
go

sp_configure "number of user connections", 10
go

sp_configure "recovery interval in minutes", 4
go

print "Sybase must be restarted for changes to take effect."
go