Results 1 to 3 of 3

Thread: Error views

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Error views

    Dear Team,

    Can any body tell in which table the stored procedure error
    details are stored.

    When any stored procedure is compiled the
    compilation errors/results are stored in which table.

    i.e equivalent to user_errors as in Oracle.

    Any help will be greatly appreciated.

    Regards,
    Sridhar

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    To the best of my knowledge there isn't an exact equivalent to what you are looking for in SQL. Serious errors are (above State 17?) are thrown into SQL's error log (in EM under Management).

    You can start a trace file using SQL Profiler or using a stored procedure to log selected events (including errors) to a table or a file (or in the case of SQL Profiler, to the screen).

    Regards,

    hmscott

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    Dear hmscott,

    Thanks for the info. When i execute any query or procedure with any syntax error, then the QueryAnalyser gives the error details from "sysmessages" table along with the procedure name, line etc. I wonder how Query Analyser is able to corelate the error messages and executed procedure. This made me curious to know, more about the storage of compilation results.

    Regards,
    Sridhar



    Originally posted by hmscott
    To the best of my knowledge there isn't an exact equivalent to what you are looking for in SQL. Serious errors are (above State 17?) are thrown into SQL's error log (in EM under Management).

    You can start a trace file using SQL Profiler or using a stored procedure to log selected events (including errors) to a table or a file (or in the case of SQL Profiler, to the screen).

    Regards,

    hmscott

Posting Permissions

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