Not really a bug, but it looks like a few incompatibilities have infiltrated the code since Dave posted about it here: http://sueetie.com/forum...on-SQL-Server-2005.aspx

Platform: w2k8 R2 running IIS7.5 and w2k3 x86 running SQL Server 2005 Enterprise (both serve as my test environment for a client, and it may well be over a year before they go to SQL 2012 – they won’t be using SQL 2008).

In the install procedure sueetie_4.0.0_procedures.sql, at lines 243, 728 and 5466…

243: declare @ExistingPostID uniqueidentifier = null

728: declare @ExistingCommentID uniqueidentifier = null

5466: declare @IsRestricted bit = 0

All should be two statements, for EG:

243: declare @ExistingPostID uniqueidentifier
244: select @ExistingPostID = null

729: declare @ExistingCommentID uniqueidentifier
730: select @ExistingCommentID = null

5468: declare @IsRestricted bit
5469: select @IsRestricted = 0

otherwise SQL 2005 throws an exception, and the install crashes.

Can these be fixed for future downloaders? It’s not a huge change, but will assist those of us that cannot easily upgrade beyond SQL 2005. For newbies this could take hours to fix & possibly drive them away.