Error 833 : trigger the error

• vijayu

  Grasshopper

  Points: 13

  More actions

  September 20, 2015 at 1:02 am

  #303195

  Hi,

  I tried so hard to recreate the error 833, through simulation using different suggested method. But was not successful. Can I manually add it in the error log of sql server. Is there any proc/function available, which accepts the (system)error number and create this in the log.

  Thanks

  Vj

• Eirikur Eiriksson

  SSC Guru

  Points: 182951

  More actions

  September 20, 2015 at 1:45 am

  #1827924

  vijayu (9/20/2015)

  ---

  Hi,

  I tried so hard to recreate the error 833, through simulation using different suggested method. But was not successful. Can I manually add it in the error log of sql server. Is there any proc/function available, which accepts the (system)error number and create this in the log.

  Thanks

  Vj

  Quick suggestion, find a slow/faulty IO subsystem and plug it to your server, maybe an old floppy drive:crazy:

  😎

  This error's cause would normally by device drivers, firmware, faulty drives etc., not something within the realm of SQL Server. Just wondering why you are trying to do this?

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  September 20, 2015 at 2:42 am

  #1827935

  What are you trying to do here? Do you just want to see what the form of the message is, or are you testing alerts or similar?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass