performance on query analyzer and .NET

Dear Sir,
I used dynamic SQL on stored procedure to do the paging in my site.
I often hit a connection with that dynamic SQl when I call it from .NET code
.
However if it run it under query analyzer, everything works fine.
Who can explain this to me and what should I do in this case?
regards,
Guoqi Zheng
http://www.ureader.comHi
How do you call it? Have you created a stored procedure which accepts
parameters?
"guoqi zheng" <no@.sorry.com> wrote in message
news:4cc7b9b7665549a4b34db8869b21a9f0@.ur
eader.com...
> Dear Sir,
> I used dynamic SQL on stored procedure to do the paging in my site.
> I often hit a connection with that dynamic SQl when I call it from .NET
> code.
> However if it run it under query analyzer, everything works fine.
> Who can explain this to me and what should I do in this case?
> regards,
> Guoqi Zheng
> http://www.ureader.com|||yes... I have a stored procedure which accept pagenr, pagesize as
parameter..
The correct sentence is that I hit a connection time out problem when I call
it from .NET code..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#7ubM76NGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Hi
> How do you call it? Have you created a stored procedure which accepts
> parameters?
>
> "guoqi zheng" <no@.sorry.com> wrote in message
> news:4cc7b9b7665549a4b34db8869b21a9f0@.ur
eader.com...
>|||It is probably because you've got a 'bad' execution pln. Try recompile the
SP and see what is going on
"Guoqi Zheng" <no@.sorry.com> wrote in message
news:dtho1p$i4i$1@.newspe.com...
> yes... I have a stored procedure which accept pagenr, pagesize as
> parameter..
> The correct sentence is that I hit a connection time out problem when I
> call
> it from .NET code..
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:#7ubM76NGHA.1132@.TK2MSFTNGP10.phx.gbl...
>|||I actually do not know how can I compile my SQL code, not to mention
recompile.
Do you know how? I thought when I create a SP, it is compile automatically?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#W72oL7NGHA.3460@.TK2MSFTNGP15.phx.gbl...
> It is probably because you've got a 'bad' execution pln. Try recompile the
> SP and see what is going on
>
>
> "Guoqi Zheng" <no@.sorry.com> wrote in message
> news:dtho1p$i4i$1@.newspe.com...
.NET[vbcol=seagreen]
>|||There is sp_recompile stored procedure, please refer to the BOL
"Guoqi Zheng" <no@.sorry.com> wrote in message
news:dths3a$jq6$1@.newspe.com...
>I actually do not know how can I compile my SQL code, not to mention
> recompile.
> Do you know how? I thought when I create a SP, it is compile
> automatically?
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:#W72oL7NGHA.3460@.TK2MSFTNGP15.phx.gbl...
> .NET
>