Just in case there's anyone else still using SQL 2005 (must have a word with my ISP!):
The 2.2.2.0 upgrade procedure errors in upgrade/mssql/procedures.sql on the line
declare @Posted datetime = (select Posted from ...
SQL 2005 doesn't support this "declare and initialise" syntax, so it needs to be changed to:
declare @Posted datetime
set @Posted = (select Posted from ...
Edited by user
7 years ago
|
Reason: add version