If you get a PK error, then you have a PK update occurring.

What I would do is change this to a SELECT, and pull out the PK columns from...

Roy Ernest (12/13/2010)

---

Brandie Tarvin (12/13/2010)

---

Wow. I just had the worst time trying to post to Grant's blog. Three times I had to try before my post went through.

You'd think he...

Tom.Thomson (12/12/2010)

---

Yes, it changes now...

Excellent response from Lowell and Gus.

Tom, new avatar?

I've used them, often as a base maintenance setup for systems that aren't stressed or critical. They have worked fine.

However when I need finer control, I tend to use custom...

Craig Farrell (12/10/2010)

---

Steve Jones - SSC Editor (12/10/2010)

---

Craig Farrell (12/10/2010)

---

I'm failing to see the problem with this... I'd purposely go out of my way to wander through said lounge on...

Jack Corbett (12/10/2010)

---

I understand both the fact that's it's not a highlight and, especially, the travel part. I just want to encourage everyone to give it a shot as...

LOL, I have to say...

Brandie Tarvin (12/10/2010)

---

Horses don't feed...

Christoph D (12/10/2010)

---

Prakash-205770 (12/9/2010)

---

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs...

AndrewJacksonZA (12/9/2010)

---

Steve Jones - SSC Editor (12/9/2010)

---

I'm not sure how much of a budget I have to change hardware, especially as this works. There is a few minute slowdown as...

Prakash-205770 (12/9/2010)

---

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs to read...

Jack Corbett (12/9/2010)

---

Jeff Moden (12/9/2010)

---

Travel money, hotel money, earn money... I'd love to make the trip from Detroit to Florida this time...

SequelSurfer (12/10/2010)

---

Is open Write access on a Production Box a little generous or am I...

TGIF

My wife is sick (and in Dallas), my middle kid coughing quite a bit. We need a weekend and some rest. Course, now it's getting cold.