use master go if exists (select * from dbo.sysobjects where id = object_id(N'[BlockLastBatch]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [BlockLastBatch] GO CREATE TABLE [BlockLastBatch] ( [spid] [int] NULL , [blocked] [int] NULL , [last_batch] [datetime] NULL ) ON [PRIMARY] GO