I just replied to another thread that's along these same lines... see if this helps:

http://www.sqlservercentral.com/Forums/Topic520202-148-1.aspx

Wow, this is a project I had to do like 3yrs ago so let me see if I can remember how I did it.

Basically, you'll put it inside a loop...

Can you truncate tables with relationships? I thought you had to delete.

Maybe I'm missing something, but both of those lines say the exact same thing don't they? Other than the 2nd line, but how do they contradict?

And it's misleading anyway...

I also have a whole set of tutorials on this on MidnightDBA.

Under the admin section.

No SQL's going to log ops no matter what. Internally it has more to do with being able to recover pages and roll things back or forward in case...

I've got a set of BCP tutorials on my MidnightDBA site below. Go to the admin section and I think they're near the top.

Yeah, that sounds more plausible.

If he's not doing filegroup backups then he'll have to restore the entire DB and roll through the logs.

Yeah that's a new one on me. However, if it doesn't happen again, or often and doesn't appear to cause any ill effects just ignore it I suppose.

I'm not terribly sure what performance gain you'll get from log backups. If you don't need logs, then put the DB in simple mode so you don't have to...

I've got a server that I do that with every week and IsRemote is always 1 and it works just fine.

Yeah, I see no issues with that.

Profiler is the only thing available.

I would guess from what I'm seeing that your problem is a classic parameter sniffing issue.

To test this, run each sp with the recompile option. You should see much...