www.pudn.com > EarnestBankdatabase.rar > CREATEEBDB.SQL

/*      Install EarnestBank database             */ 
 
set nocount    on 
USE master 
declare @dttm varchar(55) 
select  @dttm=convert(varchar,getdate(),113) 
raiserror('Starting installation of EarnestBank Database at %s ....',1,1,@dttm) with nowait 
--set dateformat mdy 
GO 
--sp_addlogin user1,null,EarnestBank 
if exists (select * from sysdatabases where name='EarnestBank') 
begin 
  raiserror('Dropping existing EarnestBank database ....',0,1) 
  DROP database EarnestBank 
end 
GO 
 
CHECKPOINT 
go 
 
raiserror('Creating EarnestBank database....',0,1) 
go 
 
   create DATABASE EarnestBank 
GO 
 
CHECKPOINT 
 
GO 
 
USE EarnestBank 
 
GO 
 
if db_name() <> 'EarnestBank' 
   raiserror('Error in installEarnestBank.SQL, "USE EarnestBank" failed!  Killing the SPID now.' 
            ,22,127) with log 
 
GO 
 
execute sp_dboption 'EarnestBank','trunc. log on chkpt.' ,'true' 
checkpoint