I can reproduce the problem following the steps described above.

Can you attach the DB backup which was created prior to the update (should be located at /tmp?!
We can mark this ticket private so only developers will be able to access the file.

From which version did you update?

Which DB driver are you using in config.php?
mssql_n, mssql_odbc or mssqlnative ?

?

ODBC Support enabled
Active Persistent Links 0
Active Links 1
ODBC library Win32

I am sorry, that's not the answer to my question. Can you please re-read?

Sorry is this what you wanted?

$databasetype = 'odbc_mssql';
$databaselocation = 'SQL02';
$databasename = 'limesurvey'

Yes, thank you. I will retest the upgrade and let you know.
The quickfix for you is to add a field 'lastpage' of type 'int' to every survey_<surveyID> table. Ideally the upgrade should have done this for you. Did you maybe upgrade with too tight security settings? You should have received lots of errors during DB upgrade, though.

Maybe you can restore the original database and try to assign root permissions to the LimeSurvey DB user, then run the upgrade again. Because if this has failed more stuff may have failed.

The workaround cured the problem.

I just noticed that only one of the two Limesurvey websites has this problem.
Perhaps one of the updates altered the db and it was skipped and or failed on one of them.

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=9262

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=9263

It was indeed an error in the update script. Thank you for bringing this to our attention.