Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pbrattin

    How To Repair Error In Indexes

    >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...
  2. pbrattin

    How To Repair Error In Indexes

    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...
  3. pbrattin

    How To Repair Error In Indexes

    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...
  4. pbrattin

    Msg 7015 - How do I fix it.

    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'...
  5. pbrattin

    Msg 7015 - How do I fix it.

    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...
  6. pbrattin

    Msg 7015 - How do I fix it.

    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...
  7. pbrattin

    Msg 7015 - How do I fix it.

    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...
  8. pbrattin

    Msg 7015 - How do I fix it.

    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.
  9. pbrattin

    Varchar

    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.
  10. pbrattin

    Msg 7015 - How do I fix it.

    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
  11. pbrattin

    SQL Server 7 and SP4 - NT 4 SP6A Required?

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

Part and Inventory Search

Back
Top