Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    9

    Unanswered: Stored Procedure TimeOut

    I have a stored procedure, one varchar(20) input parameter and 6 varchar(100) output parameters....

    I have set some prints in it to see where it is getting to before the timeout, but it doesn't get to the first print right after the variables....

    Seems like if I change the 20 character input string it runs through just fine....

    Very weird, happens both in a VB6 Program and in SQL Query Analyzer...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My first guess would be that something in the procedure isn't handling the problem value correctly. Another possibility is that the problem value isn't working with how you are passing it. Without seeing the information we suggest in the FAQ though, I'm just guessing.

    -PatP

  3. #3
    Join Date
    Jan 2006
    Posts
    9
    Here is some of the Procedure:

    ALTER PROCEDURE Get_Object_Info
    @pID as varchar(20),
    @pObjectTypeCode as varchar(100) output,
    @pObjectTypeDesc as varchar(100) output,
    @pClass as varchar(100) output,
    @pForm as varchar(100) output,
    @pLocatorClass varchar(100) output,
    @pLocatorForm varchar(100) output as

    print 'Starting' <----Never Gets Here......?

    select @pObjTypeCode = null

    ....
    ....
    other SQL Stuff here....
    ....
    ....

    return

  4. #4
    Join Date
    Jan 2006
    Posts
    9
    Actually now, within Visual Basic it times out, I just let SQL Query Analyzer run... It ran for 32 minutes and 33 seconds.... But I did finally see the "Starting"....

  5. #5
    Join Date
    Jan 2006
    Posts
    9
    ok, now I stopped and started the SQL Server services and not it runs in 0 seconds......

  6. #6
    Join Date
    Jan 2006
    Posts
    9
    Stopping and Starting SQL Server Services seems to have done the trick, but I thought I had already done that once....?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •