HI Gail,

Here it is:

DocumentID(PK,int,not null)

DocFolderID(int,null)

PublishToWeb(bit,null)

Filename(varchar(100),null)

Filesize(int,null)

ModifiedDate(datetime,null)

TableName(varchar(40),null)

EntityCode(varchar(12),null)

I'm not sure how to attached the jpg screenshot here but the execution plan only has 100% Clustered Index Scan(Clustered) on [document],[pk_document] .

The job normally runs...