Absolutely. I had a similar problem once.

BOL - refer "truncate_only"

Although the transaction log may be truncated manually, it is strongly recommended that you do not do this, as it...

I think Frank was very funny.

You'd be better off asking how long is a piece of string - but REALLY it should have more ram no matter what other...

Here's some sites I have found useful (remarkably, some of them are Msoft's)

Msoft VB Support Centre: http://support.microsoft.com/default.aspx?scid=fh;EN-AU;vbb

Msoft ADO code examples: http://msdn.microsoft.com/library/en-us/ado270/htm/mdaexamples_vb01.asp

MSoft VB Reference Documentation:

Don't think it's suitable since it is run from SQL Server but you might be interested in

CREATE VIEW USERINFO

AS

SELECT hostname, program_name, nt_username, net_address,

net_library, loginame, nt_domain

FROM...

Thanks for the effort but I am getting the developer to re-write. Sorry it took me a while to get back.

There is a logfile for DTC. Check out 'DTC Log' under System32.

Also check out DAC.EXE in the System32 folder.(DTC Admin Console)

Possibly a DTCTRACE.exe session will help.

DB

What part of the process is taking so much time ?

This will not be immediately any solution for you, but I had the same problem a while ago and it was something about name resolution on the network.

Sorry, I just...

You do know you can't run a query from EM that takes longer than 30 secs yeah ?

So if you are using QA to do this you shouldn't strike timeout...