Re: My web application is not picking up all the data in the table

Its best to work with your developer and troubleshoot the lines of code that
calls for the data and then run the same query in your Query Analyser
window.

Alternatively you could run profiler to help troubleshoot the same. If you
think the table has all the data and the app does not return it, then it
could be capped by number of rows or possibly some rowcount option being
set,etc.


"francisco - Portugal" <f_batista69@xxxxxxxxxxx> wrote in message
news:EE601359-B05A-4995-9253-92290C82A3A7@xxxxxxxxxxxxxxxx
Thanks anyway for your time, i will try to reach a developer that was
involved in the built of the application.

Merry Christmas
--
Francisco Batista
Portugal
f_batista69@xxxxxxxxxxx


"Arnie Rowland" wrote:

No where near enough information to help you. I suggest you find someone
that knows the application to help you.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"francisco - Portugal" <f_batista69@xxxxxxxxxxx> wrote in message
news:955AF918-D80E-4B0C-B626-09733B1BE251@xxxxxxxxxxxxxxxx
I'm facing a strange problems regarding an application my company is
hosting.
I'm a system engineer and not a developer, so i'm a little bit lost
here.
I have a cluster running W2000 SQL Server, this SQL server has some
linked
servers (oracle) with one of our costumers, everyday several SQL jobs
update
our SQL tables with info from that oracle servers. But for some reason,
recently the users started complaining some some of the info is not
available
on the application, after some investigation, i could confirm that
everything
is ok with the data on the costumers servers and that our tables keep
being
updated with the info, but the application can't seem to catch any of
these
info (vendor information in this case). It seems to me that at some
point
the
table has some corrupt data or something that is preventing the
application
from getting all the data.
Do you guys thing this is something with the SQL table or within the
application?
All the help and suggestions are welcome. (my msn is below)
Best regards
--
Francisco Batista
Portugal
msn: f_batista69@xxxxxxxxxxx





.

Relevant Pages

  • Re: Boolean query algorithms
    ... Does that mean the query is broken up into 2 processes that are ... also my question relates to how said queries be them sql ... Google use 'chunck servers'. ... any of the 10 chunck servers that hold each chunk of data. ...
    (alt.internet.search-engines)
  • Re: SQL slowness - cant find my original thread... added info
    ... You have several different posts in multiple newsgroups. ... The two servers are likely not exact in hardware, ... Have you looked at the query ... I have one sql 7.0 box, ...
    (microsoft.public.sqlserver.setup)
  • Re: Boolean query algorithms
    ... also my question relates to how said queries be them sql ... Google use 'chunck servers'. ... For a single query this is slightly less than 10,000 times faster than ...
    (alt.internet.search-engines)
  • Re: Linked Server: WHERE clause not being executed
    ... >> One of our companies is having problems with a query on a linked server. ... I know the default collations are different on both servers, ... > are running SQL Server, then collations shouldn't be a problem, however it ...
    (microsoft.public.sqlserver.setup)
  • Re: Linked Server: WHERE clause not being executed
    ... >> One of our companies is having problems with a query on a linked server. ... I know the default collations are different on both servers, ... > are running SQL Server, then collations shouldn't be a problem, however it ...
    (microsoft.public.sqlserver)
Loading