Thanks for that pointer. Currently DTC security settings are wide open (no authentication). I'm afraid there's something inside the provider code that requires additional privileges to join the distributed transaction.

I...

Sure, I will check MSDTC settings once again.

It's not that easy tracing DTC errors, it's going to be a pain.

I'm afraid you will have to wait some days for that...

Crap! I'm afraid I spoke too soon.

Now it refuses to participate distributed transactions.

#@#@€!!??#@!!! :angry:

...and following.

Solved! MS Support found the permissions we were missing.

The launching user had to be granted these Local Security Policies:

Create Global Objects (SeCreateGlobalPrivilege)

Impersonate a client after authentication (SeImpersonatePrivilege)

I'm setting up a...

biodun_omidiran (3/18/2011)

---

HI Member, i am considering writing a certification exam on SQL 2008 maintenance and implementation can anybody help for materials or dumb for the exam, my email address is...

Probably parallelism gets in the way, so that elapsed time is far less than CPU worker time.

That's nonsense. Transactions have to finish down their own path. If you are experiencing blocking issues, focus on the causes and tune the queries instead.

OK, found it.

Just add the /!Y parameter to DTSrun.exe and it should display the original parameters.

Uripedes Pants (3/16/2011)

---

that's the part that's really confusing me. I can create a new job scheduling a package to run. Then do it again using the same package but...

That "ID" is a crypted string that contains all the information on package name and version, server name and credentials to log in to the server that holds the DTS...

Concatenating that way is not safe. You'd better use XML for that:

CREATE FUNCTION dbo.CI(@chg_ref_num VARCHAR(10))

RETURNS VARCHAR(1000)

AS

BEGIN

DECLARE @ci VARCHAR(1000)

SET @ci = STUFF((

...

Can you post the function script?

You can create cross tabs even without PIVOT operator: check out this great article from Jeff Moden:

http://www.sqlservercentral.com/articles/T-SQL/63681/

Yes, it is possible, though it could end up performing badly. What have you tried so far?

If you need help you can come back to this thread and ask a...