There is no login on my pc. I do not enter a user id or password. Since it was my app that created those named transactions then it would...

Also, what permissions does the account that the app uses have?

The transaction is started on the client side. This is the code for the TransactionExists UDF. The others just look specifically for Add or Edit instead of either one.

What's the definition of the functions?
And where do you start the transaction?

Hi Guys,

I'm kind of stumped here and could use another set of eyes. I've got two pieces of code that are supposed to do the...

Why are you asking? What problem are you trying to solve that you need to ask that question here and in other places?

Google: "Gaps and Islands", the best stuff will probably be by Itzik Ben-Gan

Tail log is to ensure that absolutely nothing is missed, taking it switches the source DB into RESTORING state, so that nothing more can be done to it.

Please post the full query, its execution plan and the definition of the tables it references and the indexes on those tables.

We can't tune a query from seeing...

Probably because the CPU overhead and slowdown from such compression would be unacceptable.

Yes, but since the XML tags are generated from data, you need to search for a query that runs against whatever table has those columns in, and has the FOR...