Viewing exception text : sys.messages « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.messages
6> SELECT top 10 text
7> FROM sys.messages
8> WHERE
9>     message_id = 208
10>     AND language_id = 1033
11> GO
text










--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------
Invalid object name '%.*ls'.








27.9.sys.messages
27.9.1.Viewing exception text