if object_Id('CurrObj') Is Not Null drop table CurrObj go CREATE TABLE CurrObj ( db varchar( 160), nm varchar( 160), lastdt datetime, schema_ver int, crdate datetime, uid smallint, username varchar( 40) ) GO grant select, insert, update, delete on CurrObj to WebUser go if object_id( 'CurrObj') Is Null select 'Error: CurrObj Not Created' else select ' CurrObj Created' go