LittleTony (2/19/2016)

---

Sean Lange (2/19/2016)

---

You have a couple of logical concerns in your trigger. The first one is the one that is causing you issues. Why do you need to create...

LittleTony (2/19/2016)

---

GilaMonster (2/19/2016)

---

The cause is detailed in the error message.

"An explicit value for identity column in table dbo.N8_SPEC_STAT_DELETED can only be specified when a column list is used and IDENTITY_INSERT...

You have a couple of logical concerns in your trigger. The first one is the one that is causing you issues. Why do you need to create the table in...

Ed Wagner (2/18/2016)

---

Sean Lange (2/18/2016)

---

SQLRNNR (2/18/2016)

---

Sean Lange (2/18/2016)

---

Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support...

SQLRNNR (2/18/2016)

---

Sean Lange (2/18/2016)

---

Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that...

Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going...

WOW. That is going to take...

Jeffery Williams (2/16/2016)

---

The issue seems to be outside my trigger.

And, I did include the text of the error message. Error message is as follows:

would update more than one row.

And...

Luis Cazares (2/16/2016)

---

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

I might have lost my composure in my last reply.

I wonder if Java developers go to C# forums and then say that the...

In your first post you stated you are getting an error message. It would go a long way to debugging the error if you could share the error message. That...

Barely....

Jeff Moden (2/15/2016)

---

TomThomson (2/15/2016)

---

Jeff Moden (2/15/2016)

---

Sean Lange (2/15/2016)

---

Grant Fritchey (2/15/2016)

---

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested...

Grant Fritchey (2/15/2016)

---

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told...

Lynn Pettis (2/12/2016)

---

Sean Lange (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my...

Grumpy DBA (2/12/2016)

---

^ I'll be spending next week in Utah, experiencing "the greatest snow on Earth". No work related calls, emails or texts - will be carrying my personal...