Insert statement bring back error. 2

[elitecodex]

It shouldnt be... Here is my query:

INSERT INTO dbo.Notes ('CritPt_ID','Notes_Desc','Who_ID') VALUES (14,'test the testing testers',4)

The error is "Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Notes'."

I have tried Notes, dbo.Notes, dbo.[Notes] and they all return a similar error. Im at a loss... I know the table exists as I am looking right after and I have even looked at other SQL statements that actually work that reference the table. For instance...

SELECT     dbo.Notes.Notes_Desc, dbo.Notes.Date, dbo.[User].Username
FROM         dbo.[User] INNER JOIN
                      dbo.Notes ON dbo.[User].User_ID = dbo.Notes.Who_ID
WHERE     (dbo.Notes.CritPt_ID = 35)

Any help is greatly appreciated. Thanks.

 

[jhall01]

Does using the full object name work?

dbname.dbo.Notes

 

[elitecodex]

Nope. Just tried it.

 

[EdwinGene]

This message occurs if you are looking in the wrong database. I agree with jhall, always use the database name in a qualified table name.

 

[elitecodex]

So what is the next step? What else can I try?

 

[SQLSister]

What rights does the user have for the table? Maybe it has select rights only.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[jhall01]

I checked the reserved word list and notes is not on there.

Next is to check to make sure the user has access to insert into that table

 

[elitecodex]

I checked the security permissions and I have full access to it (SELECT / UPDATE / INSERT / DELETE).

Im really confused... everything has gone well up til now.

 

[vongrunt]

How about removig these tiny quotes around column names?

 

[elitecodex]

It worked. I cant believe that SQL server is that picky. Im still in the learning curve coming from MySQL

Thanks alot for everyone's help!

 

[jhall01]

LOL if that works Vongrunt deserves a star!!!!