Okay, I've narrowed my problem down to 2 tables. Tried to use checktable with repair_rebuild option but it did not work. Looks like I'm going to lose some data.

Wish...

Allen,

I had already tried that query. It returns null. The object ids being displayed (as in the excerpt from dbcc output in previous post) do not exist in sysobjects.

Sorry, Mike, I misunderstood your posting.

I believe that DBCC is kind of randomly spitting out errors. The "CHECKDB..." errors being displayed for the table that has 0 rows are some...

If I could identify the objects, I would drop & re-create them. DBCC is giving me object id numbers vs. table/index names.

Ran checkdb. Getting numerous consistency errors (26 total) on several tables. Am puzzled by some entries:

DBCC results for 'bc_wAccount_ids'.

There are 14972 rows in 292 pages for object 'bc_wAccount_ids'.

DBCC results for...

Well, I resolved my user's problem. Seems the c: drive was full and the real problem was that the swap space could not extend. After creating some room by deleting...

Desktop is win98. Don't have taskmanager or services utilities.

There must be something running because when the desktop is re-booted, get message "out of environment space" and windows will not...

version is v7. User had the database installed already. Then decided he needed the tools. But his desktop doesn't have enough memory. Now he wants to uninstall them.

Yes. But I don't want to uninstall the entire sqlserver database, just the management tools.

quote:

---

Have you tried from control panel --> Add/Remove programs ?

---