Turn Off Logging for Alter Table Statement 
Author Message
 Turn Off Logging for Alter Table Statement
Hello,

Prior to running an alter table statement is there a way
to turn off logging during its execution. My tables are
large and I always seem to be filling up my logs.

Regards,

Paul



Tue, 13 Dec 2005 21:07:06 GMT
 Turn Off Logging for Alter Table Statement

there is no way to turn logging off. it would be a disaster if you got power
outage during the alter. how would sqlserver protect your data
(rollback/commit, etc).

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net


Quote:
> Hello,

> Prior to running an alter table statement is there a way
> to turn off logging during its execution. My tables are
> large and I always seem to be filling up my logs.

> Regards,

> Paul



Tue, 13 Dec 2005 22:26:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Huge ALTER FRAGMENT with logging turned off

2. How to turn off logging of updates on a database or table

3. Turn statement results off

4. Can Transaction log be turned off?

5. Turn off logging

6. Turn off Logging of TEXT columns ?

7. Turn off logging?

8. Turning off the log file

9. Turning DTS Packaing logging ON/OFF

10. Q: Turn off the transaction-log?

11. Help! Turn Off Log

12. How do I turn off transaction logging


 
Powered by phpBB® Forum Software