if object_Id('dbaSpaceDist') Is Not Null drop table dbaSpaceDist go CREATE TABLE dbaSpaceDist ( LNm char( 40), Tot numeric( 10, 4), Used numeric( 10, 4), Prcnt numeric( 10, 4), DB char( 40), Typ char( 5), EntryDt datetime ) GO grant select, insert, update, delete on dbaSpaceDist to WebUser go if object_id( 'dbaSpaceDist') Is Null select ' dbaSpaceDist Not Created' else select ' dbaSpaceDist Created' go