[How do I...?] append data without logging?

Hello. We are using SQL SErver 2000.
We are moving appending data from one table to another table. Many millions of records.
We don't have alot of extra log space. How would I do this without it writing to the log files?
`LeYou can't turn off loging completley. Or at least in 2k you couldn't years ago my boss insisted you could and I hounded MS for proof that there was no way to completley shut it off.

I don't know how you are getting this data in but perhaps a combination of set implicit transactions on, and commits after a specific number of rows would be of help. I do a lot of this in Oracle.

[ask] how to append string to the previous select statement bounded to gridview

i have a case :

i'm using a select statement with SqlCommand and save the results in the SQLDataAdapter

and using the data table I post the result to the gridview and show it there...

my question is what should I do to append string to the SQL Command??

I'm not sure if I understand what you're asking. Can you use something like this

SqlCommand.CommandText &=" appended text "

before executing the command?

|||

yes i need the command text to be appended with some text later

thanks anyway, i think it's better to try it first :)