Strange error

[fajitapete]

Working on a new DB design and am using SQL2000 running on a 2000 server.

I have a table (1 row existing) that when I try to add another row I get an ODBC error that says only


Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'CH_Desc'.

Checked in sysobjects, nothing there named CH_Desc

Any thoughts?

 

[tlbroadbent]

Your finding is consistent with the error message. The query is trying to access an object named CH_Desc and can't find it. Verify the INSERT statement has the correct names and syntax. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[fajitapete]

Terry:

The insert statement is:

INSERT INTO DUR__DV2K.CLX.dbo.vendors
(vendor_id)
VALUES('MPS')

CH_DESC is not a name in any of the DB tables. One piece of info - Same error after I dropped and recreated the table. I built the schema using ERWIN. I tried dropping anll FK and Key constraints ans still no luck. I am headuing off to read the FAQ you suggested.

 

[fluteplr]

Did you check for any insert triggers on the table?

 

[tlbroadbent]

Check for TRIGGERS as fluteplr suggested. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[fajitapete]

Thanks Guys!! Reviewing my documentation revealed that I had strarted with an entity named CH_Desc that was later renamed. Triggers evidently don't get automatically updated in the tool. I found it and fixed it. Sometimes it takes a clean pair of eyes to see the trees.

pete