schema.sql is incorrect on 2008

Sep 9, 2010 at 11:13 AM

The schema.sql doesn't work in sql 2008.

Just  change this:

if not exists ( select * from sys.databases where name = 'WakeOnLan')begin   create database WakeOnLanend
go
use 
if exists ( select * from sys.objects where name = 'Computer' and type='U' )begin   drop table Computer end

to this:

 

if not exists ( select * from sys.databases where name = 'WakeOnLan')begin   create database WakeOnLanend
go
use WakeOnLan

go
if exists ( select * from sys.objects where name = 'Computer' and type='U' )begin   drop table Computer end