Viewing 6 posts - 1 through 6 (of 6 total)
Yes, it is critically important to call sp_xml_removedocument. The statement in the article "This handle is valid for until the connection is reset, or until the execution of sp_xml_removedocument." is...
May 12, 2005 at 10:32 am
The point is that the question did not state "WITH MARK" which is a requirement to be able to restore to it.
Knowing how these test questions work answering "Restore the...
August 27, 2004 at 2:17 pm
Lets say you are running a large batch process. If you use "WITH MARK" you can restore the database to the exact state before the batch process started.
You could also...
August 27, 2004 at 1:29 pm
The question did not specify "WITH MARK" and therefore recovery to the named transaction is not possible. I am sticking with my initial statement that this question/answer is technically incorrect.
August 27, 2004 at 10:09 am
It is ok for a scenario to be far fetched, but it has to be technically correct. This one is not! You can only restore to a "marked" transaction. For...
August 27, 2004 at 8:45 am
You can not restore to a named transaction! It requires the transaction be marked. Therefore if you actually had to restore (which I wouldn't...update the table to the correct values)...
August 27, 2004 at 7:45 am
Viewing 6 posts - 1 through 6 (of 6 total)