Following those thaughts. Try downloading the reports once they are deployed to the server... I just can't find any way to do it at the moment (web access, or...

Either that or the solution is so obvious that we totally missed it!

Yes...

It's not completly impossible. Do you have a table that's bigger than all the ram of the server??? or at least pretty darn close?

Yes, but we need a more specific question...

What do you need to do?

What have you tried?

What's not working with what you need to do?

I never had your particular problem with FTS so I can't help you much further than Google at the moment.

Good luck with this and let us know the solution when...

Does this help?

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=334759

I'm curious about this one too. I have been working on a package of reports but the only way I have so far to protect them is to host...

The only way you're going to fill up that much space in temp DB is to have a big reindexing job or huge reports.

If this comes from indexing, make sure...

You don't need to in this case and that's what you must understand.

Once you get that go in the books online and type computed columns and you'll get all the...

Yes that would work, but since the substring starts at character 1, it would make no difference other than adding page writes, reads and CPU.

Excluding the start character and assuming...

Live in Sherbrooke, Work in Pneus Supérieurs at the moment. Also work with Sico, Fordia and a few others.

Here's a second vote for Montreal, Quebec, Canada (well a bit outside, but that's where I work).

Ya, just make sure you keep backing up the log so you don't run out of space.

You may also test with smaller batches to see which is faster..

Also another way...

Please post those stats here, that way we all benefit from your experience.