1> -- Retrieve additional error information: sysmessages table
2>
3>
4> SELECT 5 / 0
5> SELECT * FROM master.dbo.sysmessages WHERE error = @@ERROR
6> GO
Msg 8134, Level 16, State 1, Server RNTSOFT\SQLEXPRESS, Line 4
Divide by zero error encountered.
error severity dlevel description
msglangid
----------- -------- ------ ----------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------- ---------
8134 16 0 Divide by zero error encountered.
1033
(1 rows affected)
1>