|
Posted by Simon Hayes on 09/08/05 14:50
You could use NOINDEX or PHYSICAL_ONLY to do a more 'lightweight' check
- that might reduce the required space, and unless you suspect you have
a problem that might be good enough for you.
In the worst case, you could run DBCC CHECKALLOC and then write a loop
to run DBCC CHECKTABLE for each table - that's equivalent (as far as I
know, but I have to admit I'm not entirely sure) to running DBCC
CHECKDB.
Simon
Navigation:
[Reply to this message]
|