I know you did a lot of the work, but I have to ask you a question.

Do you feel comfortable enough with the code you have to describe what it...

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax near '('....

I haven't fully checked your web site, but one of the things I really liked about the company I now work for is that I was able to learn a...

Yes, but how do you know you have a duplicate value in an insert ot...

GSquared (8/8/2012)

---

Evil Kraig F (8/8/2012)

---

-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book...

I have figured out what the problem is, have you?

Question, what event should cause the trigger to rollback the insert or update.

Use a temp table and simulate what should happen...

I realize that the idea is to write a trigger to accomplish allowing multiple nulls but a single unique non null value, however, this is SQL Server 2008 so why...

Steve Jones - SSC Editor (8/8/2012)

---

Links are OK here.

Just an FYI, I had someone complain about the humor/political nature of the image. I don't think...

There are several other products out there some use instead of SSMS. TOAD for SQL Server is one, and I know there are a few others even if I...

SQLRNNR (8/8/2012)

---

Jan Van der Eecken (8/8/2012)

---

Jan Van der Eecken (8/8/2012)

---

SQLRNNR (8/8/2012)

---

Lynn Pettis (8/8/2012)

---

SQLRNNR (8/8/2012)

---

D.Oc (8/8/2012)

---

LOL, made me laugh 🙂 Although it is not appropriate for this...

Which do you...

Glad to see you got it working.

Perry Whittle (8/7/2012)

---

Cough cough!!

Perry Whittle (8/7/2012)

---

Execute the modify statements first, take the db offline and then copy the files to the new location(s).

Once the db is online remove the old...

SQLKnowItAll (8/8/2012)

---

Lynn Pettis (8/8/2012)

---

I can tell you it took some playing when I was doing it. Problem is it was so long ago it is hard to remember what...

First, thank you for the setup, it will help a lot. Just one thing missing that would help more, expected results. What should the query return based on...