I have looked at the logs in windows and sql server...Nothing. It has me stumped has well.

No results returned.

I haven't set any jobs up on the server yet, but I double checked and there are no jobs running.

Good Question, It is a User Database.

For those of you that want it..this script worked for me. I then reindexed all tables affected after I ran this script.

Set NoCount On

Go

Print '--Drop Columns'

SELECT 'Alter Table '...

sorry guys for a late response to all of your answers...BUSY monday morning 🙁

For step 3 I am running sp_updatestats.

I wasn't to sure about step 5 myself. ...

I spent two days trying to figure out a solution to this problem. My problem was my computer name. It was 16 characters and server 2008 net bios will...