Something corruoted! I cannot drop table. Error 3726.

Article View: comp.databases.ms-sqlserver

Article #47

Back to comp.databases.ms-sqlserver Previous Next

#47

From: 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.

Technical Details

Message-ID: <4d1riq$o1@unix2.glink.net.hk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,33ce8f310e2d9fc0,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,33ce8f310e2d9fc0,start
X-Google-Attributes: gidf6611,public
From: cypoon@glink.net.hk (Poon Chak Yau)
Subject: Something corruoted! I cannot drop table. Error 3726.
Date: 1996/01/11
Message-ID: <4d1riq$o1@unix2.glink.net.hk>
X-Deja-AN: 134669003
organization: Global Link Information Services Ltd.
newsgroups: comp.databases.ms-sqlserver,bit.databases.mssql-l