What SQL dbcc options should be run .....

[RPowid]

SQL 6.5

What are the most critical "dbcc" options that should be run to insure the sanity of database and DBA alike? Do these have to be run in single user mode or can they be run while users are on the system?

Thank You.

[Patrick]

Try this :
http://www.swynk.com/friends/sharma/dbintegrity.asp
Patrick


------------
RPowid at 8/2/01 1:44:31 PM

SQL 6.5

What are the most critical "dbcc" options that should be run to insure the sanity of database and DBA alike? Do these have to be run in single user mode or can they be run while users are on the system?

Thank You.