--blow the table away and recreate it. IFNOTEXISTS(select*fromsys.objectswhereobject_id=object_id('PerformanceCollector.BlockAndWaitStats'))BEGINCREATETABLEPerformanceCollector.BlockAndWaitStats(ObjIdbigintidentity(1,1)notnull--key,CurrTimedatetimeNOTNULL--time of the block/wait.,spidsmallintNOTNULL--SPID ,BlockingSpidsmallintNOTNULL--SPID of the session that is blocking the request. 0 is not blocked. -2 is orphaned--dist transaction, -4 is undetermined due to state transitions ,IsHeadBlockerbitNOTNULL--finds any blocking tasks that are not themselves blocked. ,DBNamevarchar(50)NULL--database against which the request arrived ,waittimebigintNULL--total wait time for this wait type, in ms, inclusive of signal_wait_time. ,wait_typevarchar(60)NULL--name of the wait type, ie LCK_M_X, WRITELOG, NETWORKIO,etc,wait_resourcevarchar(512)NULL--if the request is blocked then what is it waiting on, ie db:file:objectid,statusvarchar(30)NOTNULL--status of the request (running, runnable, sleeping, suspended, etc),CommandTypevarchar(32)NOTNULL--type of command (DBCC, SELECT, INSERT, BACKUP LOG, etc),cpu_msintNULL--CPU used (in ms) at the request level,physical_iobigintNULL,SQLTextvarchar(MAX)NULL--text of the request,program_namevarchar(256)NOTNULL--from what application,hostnamevarchar(256)NULL--who made the call,login_namevarchar(128)NOTNULL--SQL Server login name under which the session is currently executing. ,last_batchdatetimeNOTNULL--Timestamp when the request arrived.,open_transmallintNOTNULL--number of open transactions for the request,tran_iso_levelsmallintNULL--transaction isolation level of the request,statement_start_offsetintNULL--used to calculate StatementText in the API view,statement_end_offsetintNULL,TransactionNamenvarchar(256)NULL)END;GOIFNOTEXISTS(SELECT1fromSYS.INDEXESwherename='BlockAndWaitStats_CL'andobject_id=object_id('PerformanceCollector.BlockAndWaitStats'))CREATEClusteredINDEXBlockAndWaitStats_CLONPerformanceCollector.BlockAndWaitStats(CurrTime)GO