union  kill

Chapter 12: Changes to Global Variables, Commands, and Stored Procedures

dbcc checkcatalog

dbcc checkcatalog performs sysindexes consistency checking and adds the fix parameters to fix any errors, if any. The partial syntax is:

dbcc checkcatalog [(database_name[, fix])

where fix determines whether dbcc fixes the sysindexes errors it finds. The default mode for checkcatalog is to not fix the errors. You must put the database into singleuser mode to use the fix option. The new sysindexes checks may result in new errors, not raised by dbcc checkcatalog in a previous versions of the server.





Copyright © 2004. Sybase Inc. All rights reserved. kill

View this book as PDF