SQL Server database crash/hang issues HELP

[johnlim20088]

Hi,

Hi, currently I have a timer window application and web application (Visual Studio 2005) which is connect to database (SQL Server 2005).

How I connect to database>?
I am using Visual Studio 2005 connection tools ( Microsoft.Enter prise.Library.S ql....)etc, I totally using Microsoft Built in enterprise library.

But, I always face database problem, my application always hang because of database connection usage full or crash.

is my SQL query got problem?
Any other ways can solve?

Any expert can help /guide me?

[Purple]

Hi johnlim20088,

can you post the ouput from the failing application into the thread - what can you see within the activity monitor as the application is run, during the hang and as it crashes ?

Can you also provide an overview of what the sql query is doing at the point of failure.

Regards Purple