hi there,

here is the answer --> https://www.google.com/#hl=en&sa=X&psj=1&ei=70OtT53nCYKy8ASUwrWXDQ&ved=0CBgQvwUoAQ&q=(sqlbulkcopy+OR+bcp)+(%22no+logging%22+OR+%22does+not+log%22)&spell=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=356e729b7a15c7f0&biw=1280&bih=891

or just put in google.com

(sqlbulkcopy OR bcp) ("no logging" OR "does not log")

this is really a web search... even though it doesn't look like one

i remember bcp or bulk copying from 1997 and sql server 6.5.

i think it was already there for sql server 6.0, but i am not sure.

i also remember this from sybase 11.02 and 11.5 and 1998 and 1999.

truncate doesn't log either.

there is truncate in sql server, sybase and oracle, as far as i can remember.

i am sure relational dbs have all a type of truncate and bulk copy, but maybe with different names.

sometimes logging is not required...

if you are going to delete a table with millions of rows (meaning the entire table), and you won't need to rollback, then truncate can do that job for you under a second.

but what is this i would really like?

being young enough do not know any of this for those versions of sybase and sql server.

it is like "do you remember this from sq server 6.0?"

and then i could really say "what are you talking about? i am not old enough to have worked with anything like that!"

well... too bad for me! 🙂

have an excellent day,

tonko.