Hello,
Kinda a vague title I know but i will try to explain what's going on here.
Locally i have a asp.net web app hitting a table(local DB) with 2715 records. Everything looks good so I moved it to production. I run the app in production and the table shows 2715 in sql server but the web app only returns part of the results.
Thinking something gets lost in the restore i've scripted out the DB as well with all the data and I always get the same results. To validate the code and DB i moved it to a 2nd system and everything ran as expected..web app showing all 2715 records.
I have pointed the connection string in production to the 2nd systems DB and it returned all the proper records which leads me to believe its the DB and how the app is communicating with it.
The production server is new..about 2 weeks old so I wonder if there's some setting im missing to throttle back results? Dunno..this has me stumped.
Here is the connection string I use.
Thoughts?