Nice question.

I learned something, there were no errors or typos with the answer, and the reference data supported the documentation.

The only negative comment I have is that this code:

SELECT CONVERT(char, SERVERPROPERTY('collation'),'MyDatabaseName')

Returned an error.