I have a database that has somehow become corrupt in that there is a primary key constraint in sysobjects that is no longer connected to the table (The parent_object_id is invalid). I am having diffciulty removing\reattaching this constraint, any ideas on
I am trying to use the BCP command to execute the following statement, but I keep getting the following error: Starting copy... SQLState = S1000, NativeError = 0
I'm doing initial tests with different aspects of performance using PAGE compression with SQL 2008 R2. I've noticed that rebuilding indexes using "ALTER INDEX" takes longer time with PAGE compressed indexes than with uncompressed indexes.