Evil Kraig F (1/13/2012)

---

L' Eomot Inversé (1/12/2012)

---

Compared to that guy you are perfect model of tact and good manners and politeness - there's just no time I have ever seen...

Marios Philippopoulos (1/12/2012)

---

azdzn (1/12/2012)

---

Marios Philippopoulos (1/12/2012)

---

(1) Restore database from fb with norecovery

(2) Restore log from lb2 with recovery

Does it matter that lb2 had started while the full backup was still...

My question is how would you define a reputation? Who decides? Who decides who decides?

What happens when a new person comes along and doesn't have a reputation, not because...

Typically you restore a full back with norecovery or standby and then restore transaction logs until the point you need and then restore with recovery so you can read from...

Never seen it, but by the text it seems someone either moved, renamed, or deleted the data source for that report from the report server.

L' Eomot Inversé (1/12/2012)

---

I disagree with you...

Lock escalation in and of itself wouldn't cause deadlocking, blocking and perhaps timeouts, but not deadlocks. Now it could be part of the problem when getting deadlocks, but it...

Have you tried just entering the query directly in the data source to verify you have everything correct?

Is there a schema missing from the query? FOr example...

I think you want something in this article http://msdn.microsoft.com/en-us/library/ms181714.aspx. Since it is going to do a table scan you might want to specify the TABLOCK hint since it may...

I believe that you should be able to do this. I'm not sure why you would, but I think you can.

patrickmcginnis59 (1/12/2012)

---

For clarity, the original poster insisted the decision was not his, and the original replier suggested "select * from tablethatdoesnotexist" before changing gears to criticise the raising of the...

poostwoud (1/12/2012)

---

Hello Jack,

Thank you for your response.

As you are a T-SQL person, I was thinking about the following approach I would like to discuss. As the problem lies in %...

A common issue with Database Mail is that it is blocked by anti-virus/anti-malware programs, http://wiseman-wiseguy.blogspot.com/2009/07/mystery-of-failing-database-mail.html. You should also check that smtp is opon on the firewall as outlook uses...

I do have one question, is there data past 500 characters that the customer needs?

I don't know why that would be different. The only explanation I can think of is that the statistics on the indexes are being updated by an index rebuild...