It seems to me that if your problem is disk space that possibly your real issue is capacity planning. If lack of disk space prevents you from doing regular backups...

Why do you want to do it this way? It seems contrary to best practices. Maybe you are trying to accomplish something that can be done in another way.

Now we're getting deep into design issues here. First of all, what kind of application would allow such a devasting change to a database by  data entry level person? I...

So, too broaden the discussion, what would be a good reason to use marks?

What is the difference between a named transaction and a marked transaction? BOL seems to use the terms interchangably.

From BOL:

Recovering to a Named Transaction

Microsoft® SQL Server™ 2000 supports the...

I'm not good enough to make up these things and the points don't matter that much. The questions, even the bad ones, generate good discussions. This is what's valuable to me....

Exactly.

Why would you ever roll back or restore because of a data entry mistake? Those kinds of problems should be fixed on the front end. Each of the first three...

If your OrderIDs are:

10248

10249

10250

10251

10252

Then won't your query return 10248 and 10251? The first sub-select should include ORDER BY OrderID DESC, I'm thinking.

What he said.

Didn't see this 'til after I posted a remark.

Why would anyone want to do this? It seems to me that you are assuming some specific knowledge about a particular piece of data in the table. But set theory...

OK. I'm guilty of complaining. But, in truth, I can deal with bad grammer and poor spelling unless it really interferes with the ideas being communicated. I suppose the only...

So why is it that technical types get a pass on constructing well written sentences?

Considering that many headaches are caused by ambigous specifications created...

Arggggh!

I HATE that. I looked at it 10 times and didn't catch the underscore. That's the kind of stuff that makes me pull my hair out.

Thanks. That is a nice script. What about data page fragmentation? I see alot of discussion about fragmented indexes on news groups, but not much about data. Is data fragmentation...

That's all well and good, but what weird, convoluted logic made MS define the function that way? A string is a string and if you want the white space stripped...