Like several people who have already replied, we should be 100% virtual by the end of the year, once the last couple of servers are replaced in a few months.

I would say that replication is great when it works, but when it breaks it's hell! If it was easier to fix it would probably be all you needed 😀

Drat - burnt by the badly worded question, which didn't mention express edition 🙂

Better luck next time!

(1 row(s) affected)

i.e. one row was returned. OK, so it was a row containing XML, not data from the query, but it's still a row 😉

I think I just got confused by the double negative aspect of the question -which statement is NOT true and the statement are full of Can and Cant - should...

Aaargh - I hate these trick questions! I want to learn things, not have to look out for tricks in the wording of the question! :rolleyes:

Yes! Just search for "SQL Server 2008 Build" in the main SSC Search box and you'll see both the 2008 and 2008 R2 listed 😀

Same here, so good question. Thanks.

Ouch - never thought to consider offline (all our databases are of course always online :-D)

Luckily I had had my coffee first! 😀

Can anyone explain the answer, as I didn't understand the explanation at all 🙂

L' Eomot Inversé (10/27/2011)

---

it would have been even better if instead of "executes" it had said "is invoked" or "is called" or something similar, since "executes" leaves us guessing...

Hi there, we have a report server where the data is replicated from our primary server. But I have spotted that both the MDF and LDF are on the same...

I agree - definitely more of a trick question. If you reverse the @DATE1 and @DATE2 in the BETWEEN query it actually makes quite an interesting question - will it...

So the correct answer is "it depends" 😀