Urgent - Locking problem in sql server 2000

[spaliwal]

Hi Gurus,

In my production database with 40 users load, Many of the resources are left locked even with noload in night time.
Type of Lock is 'DB' and mode is 'S'.All the locks are initiated from report queries. It unnecessary increase load on server, caused sometimes exclusive locks on the many of the resouces.

Can anybody shed light on this .

TIA,

Sheilesh

 

[SQLBill]

Is someone running a query and leaving the connection open? In otherwords, is someone connecting to your database via a frontend and not quitting/exitting the program when they are done for the day?

-SQLBill