Post reply

Exhaustive List of frequent errors on SQL Server

  • April 28, 2005 at 10:58 am

    #88852

    I am preparing a Exhaustive List of frequent errors on SQL Server on Administrator (DBA) perspective. Please all could you post the error no, and the message which you feel the errors are occurs frequently.

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • April 29, 2005 at 6:34 am

    #555863

    you might not be aware, but all error messages from sql server exist in the sysmessages table in master; around 3831 on my machine;

    select * from dbo.sysmessages

    a more common search is looking for ODBC error messages: many errors encountered occur at a client location, and the error messages there are different than the errors SQL Server may raise:

    http://download.microsoft.com/download/ado/list/1.0/win98me/en-us/odbcerr.exe

     

    HTH

     

     

     

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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