Indexes are messed up? 1

[manmaria]

I have a front end application which pulls the data from sql05 db and giving the wrong information about the data.
Recently we made the changes to the data but I thought it shouldn't be a problem for pulling the data. If I ask for customer 123 information the frontend is pulling the customer 345 information.

what could be the problem?
Thanks

 

[ptheriault]

have you tried to execute the query through query analyzer?

- Paul
- Database performance looks fine, it must be the Network!

 

[SQLBill]

A bad index won't give you wrong data. The purpose of an index is to FIND data faster. If the index is fragmented, then it will just take longer to find the data.

-SQLBill

Posting advice: FAQ481-4875

 

[manmaria]

Yes. When I ran thru SSMS, I get the right results but the front end application is showing the wrong results.

Thanks,

 

[SQLBill]

Then your application is doing something wrong.

Do you have more than one database with this type of data (a test box and production box)? Could your application be 'asking' for the data from the wrong box?

-SQLBill

Posting advice: FAQ481-4875

 

[ptheriault]

So the problem then would be with your application. and as Bill has stated, indexes are used to help you find the data faster so they would not be the cause of your problem.

- Paul
- Database performance looks fine, it must be the Network!

 

[cutiger93]

Run Profiler to see the exact SQL Statement