SELECT * FROM master.dbo.sysmessages WHERE error = @@ERROR : ERROR « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. ERROR

4> SELECT 5 / 0
5> SELECT * FROM master.dbo.sysmessages WHERE error = @@ERROR
6> GO
Msg 8134, Level 16, State 1, Server J\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)