Yes, it's rebooted nightly.

I think you can just generate a script and change the index/table names.

As I mentioned I did try that, but it only affected the SQL Logs, not the Windows Logs.

I managed to open the file by manual editing the .dtsx file and removing the two SQL Server connections from the XML. I just had to make new connections for...

No, but I found out that this statement was basically correct:

"It's almost as if one DB2 server having issues caused...

I don't think you'd be able to do it with one query... you'd have to make a cursor that goes through each column of each table and runs the select.

You...

Thanks for the response. I'm sure I detached the correct database because I eventually reattached it using the same files (then just did backup/restore to move it). Next time this...

The text box is greyed out. "Edit SQL" is also greyed out.

Thanks. I have to say though that is unfathomably stupid.

bump

Thanks for the responses. I forgot to mention but I did try updating the stats before reindexing, but it didn't help. Also I just checked and there are no nulls.

I...