Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: SQL stopping after processing over 300 select statements HELP!

    I get the following error:

    Error Number: -2147467259
    Line Number: 0
    Description:
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

    Now this happens AFTER SQL has queried over 300 select statements. I can't figure why it just STOPS.

    Is there a limit on how many statements SQL can process?
    Any ideas?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check you SQL errorlog for any additional errors.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    How do you make sense of SQL errorlog? Everything appears to be fine in the logs.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ...can't get the vertical or horizontal buttons to work....oh wait...wooosh....

    No one will know what they are....

    You need to give more detail...

    what do you mean 300 SELECTs?

    Is this a stored procedure? A script? DTS?

    Off hand...it sounds like DTS and 1 of your connections is hosed....

    Help us out a little with what you're doing...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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