Posted by The Man on 02/23/07 19:50

On Feb 23, 1:46 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> "The Man" <LeJon7...@gmail.com> wrote in message
>
> news:1172253510.989866.118890@m58g2000cwm.googlegroups.com...
>
> > Hello All:
> > I am in desparate need of assistance. We are using an application
> > called PaperVision Enterprise which takes scanned invoices and puts
> > them into a database for the purpose of easy reference to any scanned
> > invoice in the db. 2 weeks ago while trying to perform a 'match and
> > merge' of the newly scanned docs, we received a Run-time error
> > '-2147217871 (80040e31)": Timeout expired message. After being told by
> > the company who supports this software that they couldn't help me
> > since it is using a MS SQL Server Table Lookup I started googling the
> > error with minimal success. I am not very proficient with SQL so I'm
> > kind of stuck. I have narrowed this down to an ODBC run-time error,
> > but looking for some kind of guidance as to how I can resolve it. Any
> > info would be greatly appreciated. We are using MS SQL Server 2000.
>
> Really not much to go on here.
>
> It's not clear to me, did this happen just once? Or all the time?
>
> Can you open query analyzer and do a sp_who2 on the server in question?
> It's possible something has a lock on that table. Killing that (and
> determining who/why) should solve your problem.
>
> --
> Greg Moore
> SQL Server DBA Consulting
> sql (at) greenms.com http://www.greenms.com

ok i did what you have ask me to do and these are the results. Thank
you for your assistance on this issue.
also i am in the sql server enterprise manger and i killed all the
process. i tried to run the query again and i get the same error. i
opened up the sql server enterprise manager and checked the locks/
objects tree and that database is in there. Its seems like whenever i
try and run the query the database is getting locked with locked type
(DB).
there are the results of the command you told me to run:
53 sleeping sa
PVE . pvedb AWAITING COMMAND 1052 239
02/23 14:18:08 PaperVision DM Automation
Server 53

54 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:18 Microsoft(R) Windows (R) 2000 Operating
System 54

55 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:11 Microsoft(R) Windows (R) 2000 Operating
System 55

56 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 56

57 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 57

58 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 58

59 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:12 Microsoft(R) Windows (R) 2000 Operating
System 59

60 sleeping sa
PVE . pvedb AWAITING COMMAND 16 0
02/23 14:22:38 Microsoft(R) Windows (R) 2000 Operating
System 60

61 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 61

62 sleeping sa
PVE . pvedb AWAITING COMMAND 0 8
02/23 14:22:38 Microsoft(R) Windows (R) 2000 Operating
System 62

63 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 63

64 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:14 Microsoft(R) Windows (R) 2000 Operating
System 64

65 RUNNABLE sa
PVE . pvedb UNKNOWN TOKEN 123015 2253
02/23 14:23:25 PaperVision DM Automation
Server 65

66 sleeping sa
PVE . pvedb AWAITING COMMAND 0 0
02/23 14:21:15 Microsoft(R) Windows (R) 2000 Operating
System 66

67 RUNNABLE sa
PVE . pvedb SELECT INTO 31
9 02/23 14:23:01 SQL Query
Analyzer 67

[Back to original message]