Something corruoted! I cannot drop table. Error 3726.

Thread View: comp.databases.ms-sqlserver

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Poon Chak Yau Thu, 11 Jan 1996 00:00

#47

Author: Poon Chak Yau
Date: Thu, 11 Jan 1996 00:00

15 lines
991 bytes

Hello,

I cannot drop a table due to the error 3726. However, there is only
one table in the database, no view, no rule, no .....

When I check the sysobjects table, there is a foreign key entry of
another table that I had deleted. The entry was referencing the table,
that I want to drop.

I think some entries in system tables may not correct too. What should
I do to fix them? Any advice for me to avoid that happens again.

Thank you!

Poon Chak Yau.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads