Ed Wagner (3/8/2016)

---

Michael L John (3/8/2016)

---

Ed Wagner (3/7/2016)

---

jasona.work (3/7/2016)

---

A couple people have commented on this elsewhere, but what the heck...

https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

To paraphrase a bit:

Dr. Peter Venkman: This server is headed for...

Are you just ignoring the repeated comments about triggers needing to support multiple row operations? If you don't do something in your trigger to handle multiple rows in inserted/deleted you...

SQLisAwE5OmE (3/7/2016)

---

Sean Lange (3/7/2016)

---

You created your trigger on Orders but you posted the ddl for logger_all. Does the Orders table have the same columns??? The bigger issue is that your...

You created your trigger on Orders but you posted the ddl for logger_all. Does the Orders table have the same columns??? The bigger issue is that your trigger has a...

How many times are you going to post the same question and not respond to the people trying to help?

http://www.sqlservercentral.com/Forums/Topic1767262-391-1.aspx

Hi and welcome to SSC. We can't possibly offer much advice here because it is not at all clear what you are trying to do. Please take a few minutes...

sknox (3/4/2016)

---

Almost twice as many?

My math says...

And an excellent article for getting started with triggers. A must read!!

Of course this...

RonKyle (3/4/2016)

---

It looks like that thread has been getting a lot of action lately. I don't want to hijack this thread with that discussion but I would say that trying...

j-1064772 (3/4/2016)

---

Sean Lange (3/3/2016)

---

As the OP stated this data is created by multiple steps in the process. Let's say for example that InsuranceCarrierID would be required for this to be...

Hugo Kornelis (3/4/2016)

---

Sean Lange (3/4/2016)

---

Hugo Kornelis (3/4/2016)

---

Sean Lange (3/3/2016)

---

Shall I repeat the concrete example yet again? You have a column in step 3 that is required. That column cannot be...

Hugo Kornelis (3/4/2016)

---

Sean Lange (3/3/2016)

---

Shall I repeat the concrete example yet again? You have a column in step 3 that is required. That column cannot be made NOT NULL in...

I got it right by pure luck. I haven't yet had my first cup of coffee so I was too lazy to do the math. I was really hoping for...

TJT (3/3/2016)

---

Now if I want to grab information from this new row that has been entered, what is the best way before sending the email?

CREATE TRIGGER reminder2

ON Sales.Customer

AFTER INSERT, UPDATE,...