Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-02 : 17:47:02
|
faris haddad writes "Is possible to do updates to records in an SQL7 database without logging them. We have a huge table and want to do updates to one field in each record (i.e. UPDATE xxxx SET xxx = xxxx + 1). When we try and do this the log fills up rapidly, is there a way round this. Is there is a way to do it as a stored proc perhaps that disables the logging. Or maybe an "Instant commit".
Thank you in advance." |
|
|
|
|
|
1 million record field update