Interestingly enough, I goofed in my original statement. The failures were encountered on a database that had been restored from a backup.

When we pointed the application to the attached...

This may be a stupid question, but if you are using @tab to return values, why haven't you declared it as OUTPUT? Are you running this in...

1. have you examined the file in a 'neutral' editor that does NO reformating? Or in one that displays the hexidecimal equivalent of the actual text? Is...

Why not just move the physical files? detach, move, attach - the bulk of the time is spend in moving the files, not in the admin aspect.

Agree with keeping the content outside the DB. However, down the road, how will you manage the organization of these images as they grow? Or will you rely...

Something to consider: The last week of the month is ALWAYS right before the first day of the following month. So, given a date, you can create a...

Why use the EXCEPT statement at all, with a "Select * ..."? What's the original objective here (other than 'drain the swamp'?)

You wrote:

I have the following IIF statement converted from an Excel IF in a textbox expression for a Report field .

= IIF(Fields!Hazard.Value >=19 AND Fields!Hazard.Value <=76

AND(Fields!Complience.Value <=11),"Excellent",...

You may not have seen this. Perhaps it can help?

http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-expanding-log-/

Why disable the database level trigger? Why not fix the underlying cause? Did you re-enable the trigger after getting your SP in?

yeh, but how many of us are willing to go to a Gulf Coast City?

I expect that answer D has the first sign going the wrong way. But it certainly isn't nice to reduce the problem to a 50-50 guess without considering what...

did you mean to add an 'S' to the end of "XMLNAMESPACE"?

please refer to this posting - i think it will explain the structure you need to use for what you want to do.... i suspect it means nesting your stored...

For EXCEPT to work, don't you have to guarantee matching sort orders? Which you essentially demonstrated when you added the order by, right?