Which argument insp_addmessage should you configure?

A Microsoft SQL Server instance has a database named Employees. The database contains information about employees including their salary.

You must create a custom system message as an alert when an error is raised.

You need to create the custom message in the sys.messages table.

Which argument insp_addmessage should you configure?
A . @1ang
B . @with_log
C . @replace
D . @severity

View Answer

Answer: D

Explanation:

The following example adds a custom message to sys.messages.

USE master;

GO

EXEC sp_addmessage 50001, 16,

N’Percentage expects a value between 20 and 100.

Please reexecute with a more appropriate value.’;

GO

Syntax:

sp_addmessage [ @msgnum= ] msg_id , [ @severity= ] severity , [ @msgtext= ] ‘msg’

[ , [ @lang= ] ‘language’ ]

[ , [ @with_log= ] { ‘TRUE’ | ‘FALSE’ } ]

[ , [ @replace= ] ‘replace’ ]

References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addmessage-transact-sql?view=sql-server-2017