Yes, I agree with Paul's idea. Use normal constraints to ensure that children always have parents, then use the stored procedures code logic to insure that a parent is...

keil.asta (5/10/2009)

---

Yeah, I'm learning that what I need to do is use INITIALLY DEFERRED key words and set the option wait for commit to on before so that the check...

Hmm, I'm pretty sure that you can't have cyclical constraints like that and for exactly the reasons that you are raising.

It's not possible to create a new Campaign and a...

Rohit Nayak (5/10/2009)

---

Thanks for your reply

rbarryyoung - What I want to do is toi snag the first few lines of each deadlock graph to see if there's a common...

Nope, not any more:...

Jeff Moden (5/10/2009)

---

RBarryYoung (5/10/2009)

---

Jeff Moden (5/10/2009)

---

GilaMonster (5/10/2009)

---

Itzik Ben-Gan mentioned it during his precon at PASS last year. He also mentioned that the other T-SQL trick often used (select @var =...

RAID5 is not usually a good choice for SQL Server, especially for the Log files (LDF's).

adonado (5/8/2009)

---

I want to know how can i store on a column the name of the column that was modified (updated) on the table that I'm auditing, in order to...

I'm no RegEx expert but it seems like something that most editor's RegEx search should be able to do.

Paul White (5/10/2009)

---

RBarryYoung (5/10/2009)

---

Unfortunately it's only is his book, I have never seen it on the web. Further, the example in the book is incomplete (non-working) so I had...

Jeff Moden (5/10/2009)

---

RBarryYoung (5/9/2009)

---

OK, I tried downloading it and then opening it in notepad (in addition to my usual of opening it in another Firefox tab). Both of these...

Florian Reischl (5/10/2009)

---

:laugh:

Well, I googled in wrong direction. I forgot that you use acronyms for urban expressions (like WTF).

Thanks for t r a n s l a t i o...

Glad I could help.

Jeff Moden (5/10/2009)

---

GilaMonster (5/10/2009)

---

Itzik Ben-Gan mentioned it during his precon at PASS last year. He also mentioned that the other T-SQL trick often used (select @var = @var +col from...

Paul White (5/10/2009)

---

RBarryYoung (5/10/2009)

---

Actually my point was that you don't have to convert the produced string TO XML in the first place. It really is just a string concatenater...