michael.wanke (2/14/2011)
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
Interesting but not sure if this change will work on a server with several instances installed.
Rudy