Actually, if you look, you'll notice that my trigger uses the EventData() function. I just log the whole XML blob, instead of parsing it in the trigger.

Part of my...

I can easily see two companies co-branding into a single website. I'm not sure if that's applicable, but it could happen.

Also, you could easily end up with a parent...

Not a good plan. What if you end up with concurrent inserts both picking 12 as the next value? Then both succeed.

You're welcome.

select convert(datetime, DateColumn)

from MyTable;

Sounds like Halloween!

You'll also need to go to server configuration for the SQL Service and make sure the connections allow TCP/IP or Named Pipes, instead of just shared memory. SQL Express...

One of two reasons is most likely:

Lack of rights. If it's a local Windows login, it probably doesn't have any rights at all on the linked server.

Chain Windows Authentication....

What happens if you include the insert statement in your dynamic SQL string?

Those options have to be ON when you create the trigger, not when it's called.

I just tested that. I have a DDL trigger as:

USE [CVB_CW]

GO

/****** Object: DdlTrigger [DDLLog]...

As an aside, when you use a sub-query for an "IN" statement, you don't need to use Distinct in it. It just slows it down, unless SQL Server figures...

Jeff Moden (10/28/2010)

Tom.Thomson (10/28/2010)

Jeff Moden (10/27/2010)

You shouldn't mention that in an SQL forum: "Row"...

Excellent!

In the real tables, what's the execution plan look like on the updates that are blocking the inserts into the other table?

I'd expect updates of most sorts to take very...

Have you taken a look at Snapshot Isolation for this?