please solve timeout error

21 Oct 2005 11:14 AM

raghu veer

i am facing timeout error problem on my server
using dot net applications
how to solve this
will no lock option causes this

21 Oct 2005 12:54 PM

SQL

run perfmon
run a trace with profiler, determine what your longest running queries are,
improve the queries, index your tables, defragment your tables

http://sqlservercode.blogspot.com/

Show quote

"raghu veer" wrote:

> i am facing timeout error problem on my server
> using dot net applications
> how to solve this
> will no lock option causes this

21 Oct 2005 2:29 PM

jem777

Increase the query timeout seconds.

Camillo

Show quote

"raghu veer" <raghuv***@discussions.microsoft.com> wrote in message
news:69809B1D-C9A3-423F-8616-83DF6E5626DE@microsoft.com...
> i am facing timeout error problem on my server
> using dot net applications
> how to solve this
> will no lock option causes this

22 Oct 2005 7:11 AM

raghu veer

how to increase query time out
plz provide me the syntax

Show quote

"jem777" wrote:

> Increase the query timeout seconds.
>
> Camillo
>
>
> "raghu veer" <raghuv***@discussions.microsoft.com> wrote in message
> news:69809B1D-C9A3-423F-8616-83DF6E5626DE@microsoft.com...
> > i am facing timeout error problem on my server
> > using dot net applications
> > how to solve this
> > will no lock option causes this
>
>
>