error to display

• sathishmssql

  SSC Enthusiast

  Points: 138

  More actions

  October 2, 2008 at 11:42 pm

  #194372

  Hello,

  what is dbcc command to display errors.

  Regards,

  sathish.

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  October 3, 2008 at 12:02 am

  #880296

  Hello,

  I'm not 100 percent sure what your question is.

  Is it "DBCC CheckDB" that you are after?

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Wilfred van Dijk

  SSCrazy Eights

  Points: 8980

  More actions

  October 3, 2008 at 1:15 am

  #880311

  If you want the text which belongs to an error number (if that's the case), try:

  select *

  from master.sys.messages

  where message_id = ####

  (replace #### with the error number)

  If you want to simulate an error, try the RAISERROR command

  See BOL for more information about this table / RAISERROR

  Wilfred
  The best things in life are the simple things