Does anyone have any idea how to do this when the remote query contains an unknown (i.e. a variable) for the "to_date" instead of "07/11/2011" (which I presume is 7th...

We just had a similar problem here. I can confirm that stopping and restarting MSDTC finally got rid of the process.

I was a little confused by this one as I thought that the Dump command could be used to either backup a database or log, or truncate the transaction log.

I...

I also chose WHEN NOT MATCHED. However, I now know about a new command available in SS 2008 so I'm not complaining!:)

A bit of a giveaway really, considering the title of the question:hehe:

You will probably get the same execution...

I see nothing wrong with this question. It is basically trying to test whether you are using the ANSI standard JOIN syntax or the older syntax using WHERE.

E.g.

JOIN:

SELECT *

FROM...

What JLK says is true. However, leading spaces are white space. Furthermore, the explanation given:

A fast parse does not allow special characters like $, nor does it support scientific...

I believe that the answer given is incorrect as fast parse can support all of the specified formats, including leading white space characters.

According to the link in the explanation, the...

In fact it only rolls back all work in open transactions for the current CONNECTION. A user can have multiple connections with open transactions and other connections for the same...

Obviously not written by an accountant!

I'm not one myself but I'm pretty sure that having separate deposit and withdrawal methods breaks the rules for double entry book keeping allowing a real...

What a bizarre question!

To have a question with such abstract possible solutions is a bit silly. Maybe the question should have said who your boss was first and whether you...

Totally agree with all of the above answers. Daft question really as the only answer that gives sufficent space within budget won't give you the safety that you would need.

Option...

I sort of agree and I answered 'Yes' too. But on reflection, if you mark the database as 'Read-Write' then it's no longer a read only database is it

A bit of a blinkered explanation don't you think? I'm pretty sure that if I moved our system clocks forwards by an hour this...