Could be a lot of things. Parameter sniffing? Statistics out of date?

Have you tried profiling the procedure at statement level, including the actual execution plan?

I think this thread is about the same thing:

http://www.sqldev.org/sql-server-reporting-services/how-to-get-the-ipaddress-host-name-of-the-client-machine-on-which-reports-are-being-viewed-6430.shtml

Hope this helps,

Gianluca

I don't think it makes any difference on the performance side, so I would pick a single trigger.

I think it's up to personal preference.

If you think my contribution could help, send it my way.

How fast, Mr. Coffe!

This is an alternative syntax:

;WITH Formats AS (

SELECT FORMAT_NAME

FROM STATUS_MASTERS

GROUP BY FORMAT_NAME

)

SELECT FORMAT_NAME +

...

Congrats, Grant! I'm sure you'll be...

Yes, I enabled XA transactions and everything else.

What puzzles me is...

Koen (da-zero) (1/14/2011)

---

GSquared (1/14/2011)

---

Jeff Moden (1/13/2011)

---

Stefan Krzywicki (1/13/2011)

---

Maybe other folks will leave it, but I'll stop and pick it...

GSquared (1/14/2011)

---

That it works with SQL auth and not with AD auth makes me think it's a security issue. I don't know how DTC works on AS/400, but in...

OCTom (1/14/2011)

---

IIRC, the following drivers work for distributed transactions on the i:

MTS (Microsoft Transaction Server)

System i Access ODBC

IBMDASQL OLE

IBM DB2 .NET

Do you have access to the IBM drivers? I...

Thank you Roy and Greg.

Unfortunately this does not solve my issue. Basically, that thread says "don't use distributed transactions", but this is exactly what I'm trying to do.

Please note that...

Thank you for responding, Roy.

Here's my test code:

SET XACT_ABORT ON

BEGIN DISTRIBUTED TRANSACTION

--Do some stuff locally

CREATE TABLE #Test(i int, h char(1))

INSERT INTO #Test VALUES (1, '1')

--Do some stuff remotely

UPDATE

OPENQUERY(LINKEDSERVERNAME, 'SELECT...

Roy Ernest (1/14/2011)

---

Jeff Moden (1/13/2011)

---

Roy Ernest (1/13/2011)

---

This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and...

PaulB-TheOneAndOnly (1/12/2011)

---

Gianluca Sartori (1/10/2011)

---

Agreed....

Makes me think of our Oracle Service Requests...

After two months of uploading traces I still can't get my problem understood correctly.

What would happen if they lost my data? Would it...