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