Query Error Message

  • I'm getting this response in query analyzer to queries that should function properly. I can't find anything in books online about what's causing this. Any ideas?

    ODBC: Msg 0, Level 19, State 1

    SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    Connection Broken

  • Execute this "EXEC sp_MSdbuserpriv  N'ver'"

    If same error occurs refer to: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ327424

    Although it refers to SQL Ser 7 it may be relevant to you.

    If it does not give back a similar error can we have some more detail abut your client/server setup please ?

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • That sp ran fine. Returned all general SQL info. Tried re-running one of my queries, same error message.

    Running SQL2K standard on a Win2k3 Server. My login is mapped as an admin on SQL and there's no one else accessing the database at the current moment.

    Anything else you need?

  • What Service Pack is SQL Server at ?

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • What exactly are you running in Query Analyzer. I have done a few things, syntax wise wrong, that have caused this in the past.

Viewing 5 posts - 1 through 4 (of 4 total)

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