OS/2 Shareware BBS: 11 Util/11-Util.zip/TRACK.ZIP/TRACKDB.SQL

Text File | 1989-08-28 | 620b | 33 lines

/* */
/* This is for creating the performance tracking database */
/* */

use master
go

print " "
print "******** Checking database status **********"
print " "
go
if exists (select name from master.dbo.sysdatabases where name = "bench_stat")
 BEGIN
  print " "
  print "**************** Database 'bench_stat' is present ******************"
 END
else
 begin
  create database bench_stat on track_db = 2
  print " "
  print "**************** Database 'bench_stat' was created ************"
 end
go

sp_dboption bench_stat,"trunc. log on chkpt.",true
go

use bench_stat
go

checkpoint
go