This is a DTC error, not really a SQL error. Since you are only doing a select query in Q2, it should work if you remove the BEGIN TRANSACTION...

Just want to add my Thank You as well.

True story: ...

Agreed. Looking back, I have no regrets and would do it all again.

😎

Grant Fritchey (3/14/2008)

---

I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.

And Jeff,...

You guys out on the front lines while I served 4 years in the Country Club (aka Air Force). All the best to you!

😎

I think I saw the light. Is this what you are trying to get?

SELECT

crmaf_account.name AS Company,

crmaf_account.new_membershiptypename AS MemberType,

...

Okay, I reformatted the code, but I still don't really know what you are looking for. part of it is I am not sure which table is which that...

GilaMonster (3/13/2008)

---

Bracket in the wrong place. This passes a syntax check.

CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS

IF EXISTS (SELECT 1 FROM inserted i inner join deleted d

on i.ESSN...

Asking for more:

For a better response, please read the following article. It provides excellent guidance on asking for help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

There are plenty of people out here who would like to...

Grant, you and my brother would defintiely have some stories to tell. He was nuke in the Navy also. He served on CVN-65.

I wish I could remember the...

Set MAXDOP to 1 on the server, and reran the query and .........

the winner is .........

it took 30 seconds versus to 27 seconds for the straight select!!!!

This now goes back...

UNC paths are they way to go in SSIS. The only place I have had a problem with not being able to use a UNC so far is with...

I think I have come up an explanation. Part of it comes down to parallelism. The straight select has a parallelism of 1, the select distinct has a...

For a better response, please read the following article. It provides excellent guidance on asking for help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

There are plenty of people out here who would like to help, but...

And I will second Jeff's assertion.

😎