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@.ureader.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@.ureader.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
>|||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...
>> 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@.ureader.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
>>
>|||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...
> > 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@.ureader.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
> >>
> >>
> >
> >
>|||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...
>> 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...
>> >> 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@.ureader.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
>> >>
>> >>
>> >
>> >
>>
>