master.dbo.sys messages code example

Example: check message id sql server

SELECT message_id
	   ,language_id
	   ,severity
	   ,is_event_logged
	   ,[text]	
FROM [sys].[messages] 
WHERE message_id = 8134
GO