Alvin Ramard (8/12/2009)

---

Steve Jones - Editor (8/12/2009)

---

I had to read it 3 or 4 times to make sure I wasn't missing something. Is the...

What type of backup you take after modifying 15 tables is up to and part of the decision has to be based on several factors; the recovery model of the...

Please, do not double post. Please post replies here.

Have you deployed the updated package to the server, either in the file system or to msdb?

And for a moment I thought it was our PhD Candidate, that is until I checked the number of...

Or, an average of 3GB/day * 365 days...

An update, yes I solved my problem. Yes I will share it, but I intend to do so in an article that I will start writing and try to...

Tim Walker (8/12/2009)

---

Steve Jones - Editor (8/12/2009)

---

steve_melchert (8/12/2009)

---

In this economy we are running lean, and there is not time for such niceties. These folks need leadership, and they need...

mish (8/12/2009)

---

Thanks guys for your help I will probably try the Row number I dont have SQL server installed on my machine but I will probably install it tomorrow. ...

Alvin Ramard (8/12/2009)

---

Lynn Pettis (8/12/2009)

---

Alvin Ramard (8/12/2009)

---

Should I pass on this link?

Take a look at the rest of his posts. He's...

Maybe, but short integers are a heck of a lot easier to read the GUIDs.

Alvin Ramard (8/12/2009)

---

Should I pass on this link?

Take a look at the rest of his posts. He's looking for quick answers...

kgoyena (8/12/2009)

---

WITH DirectReports(parentNode, childNode, LEVEL ) AS

(

SELECT e.parentTocNodeGuid, e.tocNodeGuid, 0 AS LEVEL

FROM TocNodes AS e

WHERE ...

Gail, here's one for you😉

kgoyena (8/12/2009)

---

I looked at the sample code in BOL and the query runs but is not returning the records in the sequence I want. It returns the first level...