I was thinking of adding the attribute as I drove home last night, thanks for verifying.

Craig Farrell,

In the back of by head I thought that migrating to an empty db would be the last resort but it is looking like this is my only option....

Craig Farrell,

Yes, The table was using nvarchar(max)

pavan_srirangam,

Sorry, I was just stating that I can not create a clustered Index since I no longer have a table, this was my mistake...

Thanks, The issue is that because the space is allocated it will not be move to the end of the file for truncation and since I delted the table, I...

You need to identify which process(s) has a lock on the resources that your job is attempting to leverage. MSSQL will automatically select the deadlock victim based on how much...