May 13, 2009 at 2:45 pm
I have a call center application system written in VB6 utilizing a sql2005 database. It has been working for a long time. When an account is retrieved, contact numbers are pulled through and shown. A stored proc exists which retrieves the numbers for the application. Users complain that the app shows duplicated numbers on one shot of an account retrieval or fewer numbers on another attempt. I thought the problem had to do with stored proc so i tested it. It brings up the same number of contact numbers each time i run it for a particular account. Is it a database problem or an application one? I am under the impression it is an app one.
May 13, 2009 at 3:03 pm
Open a Profiler session on the database side and then run the app
See what commands are being sent to DB when those duplicates or inacurate results are pulled to the front app.
May 14, 2009 at 12:23 am
Thanks. Will try that and advise.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply