Tested on :
Product : Microsoft SQL Server Express Edition with Advanced Services (64-bit)
Package Name : Microsoft SQL Server 2008 R2 Express
Version : 10.50.1617.0
Just write code below
SELECT * from sys.messages
where language_id=1033
Result should be :
