home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 11 Util
/
11-Util.zip
/
BENCHSQL.ZIP
/
DB.SQL
< prev
next >
Wrap
Text File
|
1989-08-29
|
482b
|
21 lines
use master
go
print " "
print "******** Checking database status **********"
print " "
go
if exists (select name from master.dbo.sysdatabases where name = "bench")
BEGIN
print " "
print "**************** Database 'bench' is present ******************"
END
else
begin
create database bench on benchdev = 300, benchlog = 200
execute sp_logdevice bench, benchlog
print " "
print "**************** Database 'bench' was created ************"
end
go