Thats what i was hoping - but still cant see it. Dont worry...

Nope - thats exactly the problem. I have an order i would...

Thanks for the explainations.

Unfortunately i do have to worry about it. Obviously the execution plan hasnt changed in a while as people have got used to the order. ...

Nic-306421 (7/27/2012)

---

"This is an opportunity to learn new/different thing and your answer will never be wrong if you read the related subject first. "

I dont think I would agree with...

OCTom (7/19/2012)

---

I'm guessing this is an exercise in semantics. A SQL server class I took last year stated that a snapshot is only for "reverting" to a given point in...

tilew-948340 (7/19/2012)

---

I got it right, but only because of my ignorance: for me, a snapshot is a picture of the DB at a precise time, and was not suppose to...

Hi all,

I got it right - more luck then judgement though.

I am just curious of peoples views on the terminology.

Microsoft here:

http://msdn.microsoft.com/en-us/library/ms189281.aspx

Seems to start of with using the term revert -...

Hi all,

In a similar situation and also slightly annoyed. Also by the fact that 1 exam before = £99, now its 3 for the bottom tier so £297!!!!!!!

Slight cost...

Henrico Bekker (7/12/2012)

---

Koen Verbeeck (7/12/2012)

---

Maybe a little bit too easy 😀

But apparently some people still get it wrong.

Or maybe they just sneezed while picking the answer and thus accidentily clicking...

I was confused due to the lack of the correct number of columns.

For the item that failed - what is its "on failure fail parent" and "on failure fail package" (they are something like that) properties.

I would turn these both to false...

Hi,

Check your package for what its supposed to do on error? There are properties called "fail parent" and "fail package" on most tools.

If its set to not fail package,...

Anthony,

I have tried deleteing the RS cache file for this report in VS and it is still about the same time.

In terms of the rendering - the RSexecutionlog includes a...

VS is in the UK.

Yeah - it might be worth a try getting someone in the states to run..... lets see what happens.

Thanks

That is brilliant.

I tried everything.... except that. No idea why i didnt try it.

When i get a second i am going to sort this into a stored...