I don't supposed anyone had any more information on this one?

I'm in a similar situation. I only have just over a gig free on the C: drive and cannot free...

I put it there... hehe.

Its not really a temptable, its a real user table created in the main database, and once created it will stay there for the life of...

Ok, I have fixed the problem.

Table2 was a temporary table that was 100% populated and managed by triggers in order to provide fast, datawarehouse style access to the data.

This meant that even...

I cannot change the flow. Everything does what it must do in the order it does it.

The trigger ONLY updates a single value in Table2. The insert that happens to...