I haven't read your entire series yet (though I certainly intend to do so) but while scanning through this level it struck me you that you are referring to typed...

It's services that you connect a contract to, not the queue. When you have a conversation between 2 services in...

An extensive search on the internet has revealed that the functionality I need (getting the parent object that was affected by the action that the trigger fired for) is not...

Calling a CLR procedure passing in the @@procid from a T-SQL trigger works. But, if I do this, I don't have access to the SqlTriggerContext object inside the CLR code...

Jeff Moden (10/21/2012)

---

Ahhhh... getting back to the original subject of how to get the table name... I found an interesting bit of code that Remi suggested at the following URL....

Jeff Moden (10/21/2012)

---

Gosh, thanks for the extensive writeup. Unfortunately, the only way I've seen to get the table name through a CLR trigger is a nasty hack that uses...

We currently do have generated T-SQL auditing triggers. Each trigger gets generated by a stored procedure. These triggers generate an xml file from the inserted & deleted tables and send...

First off, I do not have any experience with WMIEventProviderNotifications, but I have worked a lot with Service Broker, so I may be totally off, but I think I can...

You've probably over simplified your example table, as I don't see an account column in it. I would expect a bookings table to have an account column in it, to...

For those trying to duplicate this experiment, for example to learn some Service broker basics from it, here is the same experimental code with documented improvements in it:

create database t2

go

use...

Your async handler routine should not exit after each message: Service broker expects its handlers to continue processing messages for as long as there are more messages available. As you...

Phil Parkin (8/15/2012)

....

select [Room / Shelf]

,left([Room / Shelf], charindex('/', [Room / Shelf]) - 1)

,right([Room / Shelf], len([Room / Shelf]) - charindex('/', [Room / Shelf]))

From ChemInventory

Where [Room...

Also, use proper types for your columns. Numeric values -like a salary- should not be entered as strings. If you store them as strings the values may not sort as...

The splitter function will return 3 rows per input...

I have not found more information why this happened, but after a restart of the sql server the lock that was held already for almost 14 days was released and...