The question is based on identities and defaults. You don't know how many columns, so how can you insert a row? It might seem unclear, but I think it you...

I think you have to reassess how you look at things, do lots of testing, and possibly revisit your architectures. I think this can work. Not that it should, but...

Make sure it's the same on both nodes as well.

It's a round robin type thing.

You can do one file / filegroup and get this granuarity.

Are you talking about paging? There are articles on this site dealing with that.

http://www.sqlservercentral.com/articles/Advanced+Querying/3181/

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