I just upgraded tonight to the latest release of BlogCFC, (what runs this blog) and realized that there is not an upgrade script for mssql. I edited the one provided for mysql and here it is:
ALTER TABLE tblblogcomments
ADD killcomment varchar(35) NULL
ALTER TABLE tblblogcomments
ADD subscribeonly int NULL
ALTER TABLE tblblogentries
ADD summary varchar(255) NULL
ALTER TABLE tblblogentries
ADD subtitle varchar(100) NULL
ALTER TABLE tblblogentries
ADD keywords varchar(100) NULL
ALTER TABLE tblblogentries
ADD duration varchar(10) NULL