Does it run OK if you add with recompile?

SQL Server backups of all types are an online operation. Having people working while they occur is no problem ta all. Are you taking log backups throught the...

Personally, rather than regenerate it like that for every query, I'd take the output and put it into a Date Dimension table

Err- Lynn...

Ah also...

Might be...

L' Eomot Inversé (5/2/2012)

---

There are two common reasons: first is that the person involved is being pushed into a management role against their will - that will hardly ever work;...

TravisDBA (5/1/2012)

---

Nothing is more frustrating than trying to relate a difficult technical issue to a non-technical manager after he/she asks you what the problem is. My dad used to have...

majorbloodnock (5/1/2012)

---

Eric M Russell (5/1/2012)

---

Most sales professions get paid on commission, so it seems to me that a company's "best" sales people (those who consistently open a large number of...

Are the filenames for the logs on both servers the same?

Have you tried checking that the appropriate permissions are in place? Does the login being used actually have access to that directory?

Just a gut feeling - never used C...

Have you tried taking the Access query and refactoring it appropriately as a SQL Server stored procedure and calling that from access instead?

As far as I'm aware, you cannot take a table snapshot (but there are rather talented people on here who may prove me wrong). If I were you I'd...

jfogel (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

I have an idea, let's make all drugs illegal. I'm sorry, I watch TV and some of the side-effects of some drugs are worse than the...

Lynn Pettis (4/24/2012)

---

david.wright-948385 (4/24/2012)

---

So your premise is that your everyday law...