That worked Suresh. Thanks! As usual it's something simple that escaped me :P.

Thanks to both of you for the solutions. I'll be testing both of them to see what performs better (more for my own education). I'm not actually sure how often...

Ahh that fixed it. My whole point was to be pointed in the right direction (which this most certainly did!). I will definitely keep that in mind for future problems.

Thanks...

I've tried running this code and these are the errors I'm getting:

Msg 8155, Level 16, State 2, Line 23

No column was specified for column 1 of 'drvU'.

Msg 8155, Level 16,...

The version is 9.0.4035.

The current command for rebuilding is pulling the names from sql server so I doubt a case mismatch is the problem. According to the statements they're matching...

You're in luck. I just had to deal withi this exact same problem over the last few days. The primary culprit is you are missing some files from your C:\Windows\Installer...