I really don't know what it means, sorry. The only thing I can find that i similar is this post, which is for SQL 2008, and doesn't really offer a...

Could there be a sporadic connection problem? That's what the error message seems to suggest.

Also, try checking the logs of the agent jobs on the publisher, distributor and subscriber. And...

Great question, thanks.

I really like full-text indexing, but have only had a chance to use it a couple of time in production.

Still managed to get it wrong though, due to...

No problem Elizabeth. Good luck whatever you decide, and I hope the presentation goes well. Let me know if I can be any more help at any time.

Duncan

Hi Elizabeth

According to the Microsoft Learning website 70-450 will be retired in January next year, which does give you a bit of time yet. The dilemma would therefore be whether...

Hi

So which exams have you done so far? Are you still working on the 2008 ones?

If you've got a few to take and are not in a hurry, there's always...

Hi Elizabeth

I just used the book questions, which were ok for making sure I'd learnt everything but not for exam practice. However, I've done so many of these exams now...

Hi Elizabeth

I know this post is a month old so you may have started taking the tests already, but I've just completed the last of the three upgrade exams, so...

Matthew Darwin (7/17/2013)

---

OK, so I recreated the table without the identity column, and hey presto, minimal logging taking place.

So it would seem that the identity insert was causing the problem....

Hi Matthew

This page gives a pretty good idea of the requirements for minimal logging, although it doesn't mention the identity column specification.

You can try using the fn_dblog function (SELECT *...

Andrew G (7/11/2013)

---

Just wanted to add that I also encountered this issue today. Also on SQL2008R2 SP1.

Very weird, the error is reported on the publisher but is referring to...

paul.knibbs (5/30/2013)

---

Duncan Pryde (5/30/2013)

If the same values were put in both columns, we would still get different numbers of rows returned for all values of @x greater than 3 since...

Interesting question, and I didn't spot the different values in each column either.

So there are two things going on here to confuse us. First is the fact that different values...

Glad you got it figured out.

Duncan

kritika (4/18/2013)

---

well i tried that also it didnt work

what i noticed after an hr of R&D is

select * from email_history_log ehl (nolock)

join email_history ehe (nolock) on ehe.message_stub = ehl.message_stub

join survey_email_history...