Error on the SQL server,

Last post 11-20-2008 11:32 AM by shabnyc. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 11-14-2008 8:45 AM

    • shabnyc
    • Top 500 Contributor
    • Joined on 04-18-2007
    • CT USA
    • Posts 61

    Error on the SQL server,

    Reply Contact

    Hi all,

    one of the SQL 2000 servers we have keeps giving this error(

    An error occurred on line 2185 while executing script 'SQL Server 2000 Space Analysis'

    )

    after this no can logon to the sql instance. this is a production server. anyone have any idea what might be the problem, help is appreciated?
    ShabCT

  • 11-14-2008 11:27 AM In reply to

    Re: Error on the SQL server,

    Reply Contact
    Check: http://www.eggheadcafe.com/aspnet_answers/mom/May2006/post26870113.asp
    Luis Martin
    Moderator
    SQL-Server-Performance.com

    When the power of love overcomes the love of the power, the world will know peace.

    J. Hendrix


    All postings are provided “AS IS” with no warranties for accuracy.

  • 11-16-2008 7:06 PM In reply to

    • shabnyc
    • Top 500 Contributor
    • Joined on 04-18-2007
    • CT USA
    • Posts 61

    Re: Error on the SQL server,

    Reply Contact

    Thanks Luis, I will try putting more time between jobs running,
     

    ShabCT

  • 11-20-2008 11:32 AM In reply to

    • shabnyc
    • Top 500 Contributor
    • Joined on 04-18-2007
    • CT USA
    • Posts 61

    Re: Error on the SQL server,

    Reply Contact

    I did make time between jobs, but this did not help. The problem now is more complicated where sometimes I cant login and/or see the sql instance. when try to connect to SQL server I and every user get error saying login failed for user 'NULL'. when I restart the sql service, the SQL server runs normal. this seem to happen everyweek. any thoughts? 

    ShabCT
Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.