And there's me...

Ninja's_RGR'us (3/2/2011)

---

Duncan Pryde (3/2/2011)

---

Ninja's_RGR'us (3/1/2011)

---

What about the questions where it could be multiple choices and there's actually just 1 valid answer? Those are the harder questions we have here....

There was a similar question on Feb 9th which asked about the same user in the same database. In that case the answer was that the same appdomain was used,...

Really nice question by the way, I learnt a few new things today.

Thanks.

Ninja's_RGR'us (3/1/2011)

---

What about the questions where it could be multiple choices and there's actually just 1 valid answer? Those are the harder questions we have here. Bottom line...

grahamc (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

Great question, thanks.

I could deduce the correct answer since I ran the query on my development machine.

Not all results were zero and the columns aren't nullable, so...

David Todd-242471 (2/24/2011)

---

Hi Folks,

I've been thinking about this question, and looked through a fair bunch of Paul Randal's stuff around this issue and figure that the correct answer is actually...

Thanks everyone for a lively discussion. I honestly thought this would be a nice uncontroversial question! Apart from it actually being incomplete (or incorrect, depending on your point of view),...

SKYBVI, Lady Di, MG-148046 and anyone else who picked SSMS because you can do this in 2008:

In case you haven't read my previous posts, I apologise for the question -...

Following James' observations, I've requested that the question be changed to apply only to SQL Server 2005, and the explanation reworded to add that you can in fact use SSMS...

James Lean (2/23/2011)

---

You CAN change the default backup directory using SSMS very easily:-

- From Object Explorer, right-click on the server and choose Facets.

- In the Facet dropdown, choose Server Settings.

-...

Thanks for the positive responses, and a special thanks to SQL Super Star for the additional code.

Nice question - had the same "doh!" moment as lots of other people by the look of it!

Thanks for the question

Shawn Melton (2/17/2011)

---

For all purposes then you should not rely on bulk-logged recovery model if you want point-in-time restore for any transaction. Even though you can in some situations do...