- If the application is holding locks, does that mean you suspect that it is executing more than one query apart from the one i'm analyzing and that is locking...

I thought that the SQL Profiler gave the time it took to execute the Query, not how long it took to execute and send back? are you sure about this?...

Here is the query, it is a bit of a monster.

I have just created a stored procedure, to see if there will be a difference, but need to get the...

I think the simplest solution is to use the simple Mode as has been suggested by a couple of you.

I Thank you all very much for your help!

Eduardo

Thank you all for your time and suggestions, it is much appreciated.

I am now suspecting that this query is not the main culprit, i have posted a thread with the...

Thank you very much for taking the time to answer and even reconstructing the query!

I have tried it and i get

Server: Msg 107, Level 16, State 2, Line 1

The...

Thanks for your reply,

I'm assured by our IT staff that transaction log should be happening, so it must be enabled.

Is it possible that something could be preventing the backup of...