SP **

From: maryam rezvani (rezvani_at_parskhazar.net)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 09:51:36 +0300

Hi

I've a Stored procedure in SQL server 2000 and when I run it in Query
analyzer there's no problem
and it fetches the result in 2 seconds,but when I run it in VB6 via an ADO
connection with
executing it throght a command and ofcourse I make the connection timout
property more than before,
but again "error:connection timout" appearred!!
and there's a very very funny solution for it which wasdiscovered by me
randomly:
when I alter procedure with it's script again in Query analyzer whithout any
new changes then it work well.!!!??
why??

any help greatly thankful.

Relevant Pages

  • SQL2K Question
    ... I have a Stored Procedure that is taking an unusual amount of time ... I have analyzed the execution plan via Query Analyzer and I have identified ... analyzed the indexes and added other index fields in the query with no luck. ...
    (microsoft.public.sqlserver.programming)
  • Incomplete result set returned by record select - Crystal XI, MS SQL stored procedure
    ... I've got a stored procedure written in T-SQL. ... When I use Query ... query analyzer. ... That functions fine, the prompts seem to work OK, I ...
    (microsoft.public.vb.crystal)
  • Re: Help with where clause in Stored proc and Qry Analyzer getting different rec. counts
    ... type of fkarInvFlagRefID is charor some nullable char ... you run this query. ... analyzer) and stored procedure and procedure call. ... If you are calling the stored procedure from somewhere other than query ...
    (microsoft.public.sqlserver.programming)
  • Re: Bookmark Lookups...
    ... Query Analyzer and I have identified what portion of the Stored Procedure ... bookmark lookups), but if I use the same values assigning them to varchar, ...
    (microsoft.public.sqlserver.programming)
  • Re: noise words, @@ERROR, and stop and resume indexing
    ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure. ...
    (microsoft.public.sqlserver.fulltext)
Loading