recently added a new table to an existing database. Data is entered
into the db via a web front end, using PHP 5. I am not a php developer.
developer is trying to build a search query against the new table
(there is data in the table). From the page he is working on, he can
run a query against any other table in the database, but not against the
I have verified that the user login account he is
using has the requisite permissions. I can log in to SSMS with those
credentials and runs a select * from the table in question, and it
returns all the rows. I can run an osql statement from my desktop and
from the developers desktop utilizing the same credentials, and return
I've run a Profiler trace, and watched while he queries
other tables and when he queries the new table. When he queries the
"customer" table, which has 161 records in it, I see 485 Reads. When he
queries the new table "esb_rt", there are 0 reads.
I think this
is a PHP issue. The developer thinks it's a SQL issue. Can anyone
provide any ideas where to look that I'm not looking?