SQL Server could not spawn process_loginread thread.

  • I am also getting this error showing in my log all of a sudden recently.  I have all the most recent SP's and running SQL Server 2K.  I have linked servers to Oracle 8I and Oracle 10G.  Is there any chance my dependancies on linked servers are causing SQL Server to run into issues?

     

     

  • Take a look of the following article which may apply to your issue...

    FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000

    http://support.microsoft.com/kb/893312

    There may not be enough virtual memory when you have a large number of databases in SQL Server

    http://support.microsoft.com/kb/316749

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply