When you say it goes away, do you mean you

- get error in the log

- run DBCC and there are no errors?

- reboot

- get the error again?

Typically these errors are...

My guess is that vendors are just behind getting something done. I've seen this before with other exams, often because there weren't enough authors interested, or they were busy on...

There is no risk of changing data in a hot backup in SQL Server. The log records are used to ensure this is completely safe.

I'd second Lowell's advice here. Don't really know of a better way.

I'm sure someone will appreciate your update.

Thanks for the info.

I agree with Barry that it's pretty easy to implement, but it can be complex to understand and keep it straight in your head which rows are visible to which...

Hey! I know I'm not the most...

Lynn, I tend to agree with you. Good post.

You need to post all the code. In the first post you have an error for the '#temp_able'. In the last post, you don't show that.

something is different between...

A guy last night at the Denver meeting said he wanted to do the 24 hours. Crazy.

The backup starts throwing out pages. If a page changes while the backup is running, the associated log records are then put in the backup at the end for roll...

A table that starts with # is a local temporary table. It exists on that server only, and must be created. If you created it on primary, it doesn't exist...

I missed that subtlety with 1 and 2. I've changed the answers to clean things up and will award back points.

Jeff and Michael have good reasons here for noting this. We might change to allow some voting, but i'm torn about it. Not sure that it is the best...

You need a "both" option as well.

I have a netbook, laptop, 2 desktops running Windows. We have an iMac for the kids as well. Like them all. I'd get a...