I do like the idea of removing the cursor. Either an update as already suggested or the SQLServerName column could be changed to use a default:

[SQLServerName] [nvarchar](150) NULL DEFAULT @@servername