Search results for query: *

>I'm unclear from your reply if you actually did either of those steps. >Did you run the repair on the sysindexes table? Yes, I tried two. One, the one you specified: DBCC CHECKTABLE ('sysindexes', REPAIR_REBUILD) It returns the same consistency error messages as DBCC CHECKDB and DBCC...

Good idea. But it did not work. I get the same connection broken message. I tried the following: DBCC DBREPAIR('WPBC', repairindex, 'Employee',1) and it said it worked. But it did not. I cannot even get the following to work: Select * From SysIndexes Where id=object_id('Employee') It...

How can I repair this problem. I run this: dbcc checkdb ( 'WPBCTEST', REPAIR_ALLOW_DATA_LOSS) with NO_INFOMSGS and I get this: Server: Msg 8929, Level 16, State 1, Line 1 Object ID 2: Errors found in text ID 92821913600 owned by data record identified by RID = (1:134968:0) id = 1894206444...

I can add rows but I cannot drop the table. I get the same doggone Connection Broken msg when I try to drop the table as I do when I try to drop the index. I think I have figured out what the problem is but I don't know how to fix it. I run this: dbcc checkdb ( 'WPBCTEST'...

I run both: DBCC CHECKTABLE ('Employee', REPAIR_REBUILD) DBCC CHECKTABLE ('Employee', REPAIR_ALLOW_DATA_LOSS) and they return no error messages. But afterward when I run the foloowing stmts: DBCC CHECKDB DBCC DBREINDEX ('Employee') I get the same Connection Broken error. If I could...

I have not resolved this problem. I get the same error message from the following stmts: DBCC DBREINDEX DROP INDEX EMPLOYEE.EMPLOYEE0 DROP TABLE EMPLOYEE That error message is: Server: Msg 7105, Level 22, State 6, Line 1 Page (1:1215), slot 1 for text, ntext, or image node does not exist...

Deleting the table is my last resort because there are lots of dependencies on the Employee table. I guess I will delete it if I can't figure out a way to repair it. However, I can't delete the table even if I want to. I tried to drop it and the drop statement returned the same error...

I tried DBCC CHECKTABLE but it does not help. Actually I got the message first when I ran DBCC CHECKDB and it returns the same error, which is on the primary key of the Employee table. I am trying to figure out how to do a repair on the primary key index of this table. I just want to drop it.

It would probably be easier to make this field "text" instead of "varchar". A "text" field is variable length can hold over 2 trillion charcters.

The table contains no data. What can I do? I run: ALTER TABLE [dbo].[Employee] Drop CONSTRAINT [Employee0] I get: Server: Msg 7105, Level 22, State 6, Line 1 Page (1:1215), slot 1 for text, ntext, or image node does not exist. Connection Broken

I don't know if it's required but you should do it anyway. There are some real benefits to 6a over 6.