As I have installed only SQL Server 2012 and 2014 instances , I am obtaining only the following message
Warning! The maximum key length is 900 bytes. The index 'PK__QoTD__2CB664DD844B62FA' has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.
The creation is OK , any insert is OK except of course when the value for Title has a length > 900 bytes.
I have not searched in the BOL but I am surprised that I have got only a warning with the 2012/2014 versions when 2008 would give an error message at the creation of the table.
Is it an error in the BOL for 2012/2014 ? If yes , It could be an error and I will post a request to modify the SQL Server BOL (2012/2014).