The second part of your last post is pretty much what I found in my study book, but it didn't have any accompanying definitions, which is what confused me. ...

Okay, now there's something I didn't consider at all. Because if you had to restore, you would have to restore every single last transaction log that goes along with...

I'm betting it'll be fixed on Sunday. @=) That's when DST ends here in the States.

Of course, the site could be bugging a bit on its DST...

That's pretty much what I thought, but then I've missed obvious points from these book examples before, so I figured I'd double check.

Thanks everyone for your comments. I really...

On the other hand, you really have to appreciate an author with a great sense of humor and a strong grasp of reality. Just got to the restore portion...

Pam,

Thank you so much for your reply. That's MUCH better than the explanation of latches I have at hand and once I read what you posted, I actually understood...

The only option I can think of is to do a bunch of LEFT OUTER JOINS to db1.sys.objects, db2.sys.objects, etc.

Andras is correct. You can't order by the order in an IN clause. You can order by column ordinal positions, but since these are row results, that doesn't...

Ben,

I'm not trying to flame, but your "definition" bugs me, so I find myself needing to respond.

Have you actually read Microsoft's NDA and their EULA regarding their certification tests? ...

Not according to Microsoft.

And not according to the thousands of teachers who at Elementary, Junior High, Senior High, College and University institutions across the United States. Using a...

WHHHAAAAAAAAAAAAAAATTTTT? You have higher priority items on your list... like keeping the forums running, publishing articles and protecting the site from DOS attacks and such???? Say it ain't...

Really? Because I heard from someone else that they can if, and only if, they are pointing out errors on the exam. But I have no direct experience...

Adam,

Theoretically, you might be right, but in the past I've actually seen an exam where they gave me an example of a database in Simple recovery mode and started off...

Becase as long as you pass, you pass, regardless of the exam version. @=)

And if you make a note on the Betas (or an exam) about a problem being wrong...

Ditto to Adam's post.

When I was still working retail / customer service, I created Access databases to track my supply orders and other items. I didn't need to do...