Transaction log

[Tim]

Hi,

Is there any way of avoiding writing to the transaction log during insert
and things like that. I am running a VB applciaiton and when I call a store
procedure it takes forever to finish. I figure if I am able to avoid writing
to the transaction log it will be faster. Thanks.

tim

[Paul Mc]

G'day Tim.

As far as I have ever heard, there is no way to turn off logging, apart from
bcp or "insert into" operations...

The following article applies to all versions of SQL server from 4 - 7, and
I would assume for 8 as well...
http://support.microsoft.com/support...s/Q59/4/62.ASP

However, there are usually better ways to tune your SQL that by this type
of step. If you post it here, we may be able to make some suggestions...

Cheers,
Paul