SQL SERVER FORMAT MESSAGE FORMULA

SQL SERVER FORMAT MESSAGE FORMULA

-- THEORY: SELECT FORMATMESSAGE([ENTER A WHOLE NUMBER]);

-- EXAMPLES:

SELECT FORMATMESSAGE(20009);

-- RESULT 1: The article '(null)' could not be added to the publication '(null)'.

SELECT FORMATMESSAGE(20012);

-- RESULT 2: The subscription type '(null)' is not allowed on publication '(null)'.

SELECT FORMATMESSAGE(20013);

-- RESULT 3: The publication property '(null)' cannot be changed when there are subscriptions on it.

SELECT FORMATMESSAGE(20014);

-- RESULT: Invalid @schema_option value.