How do I turn off the transaction logging of a SQLServer database from VBA code?
It is NOT possible to turn of the Transaction Log.
The closest you can get is to set the DB to Truncate Log on checkpoint.
OR run non logged operations. Unfortunately that leaves you with BCP.
BCP really isnt all that bad, and actually works very well provided the
source and destination database Tables are identical.
Otherwise Excel works very well as a tool to hack the columns of data.
The Transfer Manager in SQL enterprise manager uses BCP to do the actuall
data transfer.
Your ideal solution will depend upon your exact requirements.
If you need any further help, please email me.
Steve Wort
