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-08-10 : 08:12:10
|
| Charlie writes "We have a SQL7.0 database that stores medical records for a hospital emergency room. The system is used 24x7 and we constantly run into problems where inserts fail when the nightly integrity checks run. They are running as close to off hours as possible, (4-5am), but we still get complaints. I've tried doing the checks with the NOINDEX option but that doesn't seem to help.Does anyone know if there is a way we can still do nightly checks and avoid this problem?ThanksCharlie" |
|
|
|
|
|
DBCC Blocking