Warning: The table "Temp" has been created, but its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit.
Msg 511, Level 16, State 1, Line 507
Cannot create a row of size 13079 which is greater than the allowable maximum row size of 8060.
The statement has been terminated.
The warning and the error message is self explanatory
It says that though the table is created, if you try and insert a row that exceeds 8060 bytes of data in this table, the INSERT/UPDATE will fail
Your INSERT statement tries to insert data which requires 13079 bytes and hence results in an error
You can check the below mentioned link for Maximum Capacity Specifications for SQL Server
http://msdn.microsoft.com/en-us/library/ms143432%28v=sql.105%29.aspx
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/