Robert-378556 (9/4/2013)

---

webrunner (9/3/2013)

---

Fascinating idea. Does anyone have any suggestions for sites or books that discuss how to integrate a sensor and a SQL database? Sounds like that would be fun...

Never mind. It is 'dsh' as in 'commandshell'.

🙂

The question has 'dsh' and the explanation has 'dhs' - which is it?

Fascinating idea. Does anyone have any suggestions for sites or books that discuss how to integrate a sensor and a SQL database? Sounds like that would be fun to try.

Thanks,

webrunner

Jamie Ingram-729524 (8/28/2013)

---

That's sort of what I was aiming at.

You can populate as many tables as you want with data and just use cartesian joins to give the bulk.

I have...

Yes, that is usually the challenge. Especially a lot of repeats of the same dummy data.

Perhaps an idea would be to have a framework, and depending on what data...

Great reply, Jeff. I wondered the same things (low number of stars, hard-coded data), but think this is a great topic and I applaud the author for taking a crack...

Thanks once more, Scott.

I did realize the INSTEAD OF trigger would cancel the original delete that was issued 🙂 but didn't realize the care needed in using ROLLBACK or in...

Thanks, Scott,

By "prevents the actual statement from running" do you mean the original DELETE statement? And then any code in the trigger after the ROLLBACK does get run? That would...

Thanks, Eugene, I see. I had commented out the ROLLBACK for my INSTEAD OF trigger so didn't understand the behavior you just posted with the test code. Perhaps Scott was...

Eugene Elutin (7/25/2013)

---

webrunner (7/25/2013)

---

ScottPletcher (7/24/2013)

---

webrunner (7/24/2013)

---

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear...

ScottPletcher (7/24/2013)

---

webrunner (7/24/2013)

---

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear from the UI...

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear from the UI (but actually...

Thanks for the advice.

It looks like switching the order of the code allowed me to write to the log table. See the code below. I also added a ROLLBACK statement.

When...

Lowell (7/9/2013)

---

you can get the IP address for connections, if that helps;

compare this to sp_who2, and see if it helps you any:

select

conns.client_net_address,

conns.auth_scheme,

sess.* from sys.dm_exec_sessions sess

LEFT OUTER JOIN sys.dm_exec_connections conns...