Error Msg 7314, Level 16, State 1

[fuyuki11]

Hello,

When trying to complie a stored proc, I get the following error message for one of the tables it is looking at:

OLE DB provider 'A' does not contain table '"B"."dbo"."EMPLOYEES"'. The table either does not exist or the current user does not have permissions on that table.

I checked with my DBA and I have read/write access to the above table.

Has anyone come accross this before? How can I resolve it?

 

[NoCoolHandle]

Get rid of the double qotes and replace them with squar brackets..

Depending on your ansi settings it might not be treating the values as an object name...

"set ansi quotes on" I think is the magic setting, but I tend to avoid double qoutes like the plague..

Rob