I'd agree with Gus. I'd also start by being sure you are using N' data types (Nvarchar, ntext, etc.)

Haven't tested it, but this (http://msdn.microsoft.com/en-us/library/ms186865.aspx) seems to indicate it does.

It doesn't prevent another process or user from deleting them.

FWIW, I'd consider this the way to do things. Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.

I believe we used .dat in the old days (pre v6.5) at some point. That and .dmp were used, but they were by convention, no reason not to use them....

I'm not sure what is wrong, but how are you retrieving the backups from tape? There should be a header that you can read with the RESTORE HEADERONLY.

Also, it's recommended...

Interesting thoughts. I would have thought that most people wouldn't prune old procs, but quite a few people do seem to do it.

And a great point about DR procs. They...

Moved to data corruption.

As Gail mentioned the error log usually has an error code and description that can explain many of the reasons why a database gets suspect.

If it's a...

Are they? Salesforce.com is essentially a cloud service. That much different from an app? You wouldn't have to send all the images, formatting, etc. down, just the data. The XBOX...

You would need to provide more detail, or ask more questions for these, IMHO.

We are happy to help, but we want to see you do work. Thanks for putting in...

:), not bad.

How about a SQL JD, just argue the way things should be done in the database all day

It's not necessarily question of smart of dumb. It's easy to keep control of your app, but...

Interesting split here. I'm mostly in the camp of not worrying about old stuff. I can see the issues with validating the old procs for upgrades/changes, so perhaps it's worth...

You can "reverse" the flow of geothermal. It's basically a heat pump and you jump the heat into the Earth, which presumably can absorb it. I'm not sure how much...

It shouldn't change. Have you checked if the values are being set in the tables? Maybe the GUI is hosed.

There should be some script that resets values. I've had scripts...

I don't know of a good reason to set this. I think it was something you might have altered in v6.5. Or maybe someone was getting an error at some...