Does anyone have an example of setting NO LOGGING for an SQL Statement? I
have a user who's running purges and it's killing my TransLog. Any help
would be appreciated.

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-----Original Message-----
From: Mark.[Email Address Removed] Monday, February 25, 2002 06:25
To: [Email Address Removed] RE: Transaction Log ...


No, you can't. The only way to do it is to set truncate log on checkpoint
option on, and then do the load in batches. BCP has a batch size parameter
to help you do this.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Phil Shuttleworth [mailto:Phil.[Email Address Removed] 25 February 2002 11:25
To: Lazydba (E-mail)
Subject: Transaction Log ...


Does anyone know if it is possible to switch off the Transaction log in SQL
Server 7.0, in order to run a massive load program, for example, and if so
how do you do it?

Phil.

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged or
otherwise protected from disclosure. If you are not the intended recipient,
please telephone or email the sender and delete this message and any
attachment from your system. If you are not the intended recipient you must
not copy this message or attachment or disclose the contents to any other
person.

For further information about Clifford Chance please see our website at
http://www.cliffordchance.com or refer to any Clifford Chance office.

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page