I had to modify the example code very slightly to get the code to run:

INSERT INTO test.TableWithIndexes

VALUES(1, 'Defrabuliser', 'Blue', '2009-04-30', 19.99, 0),

(15, 'Unbobulator', 'Green', '2012-01-13', 85.00, 0),

(22, 'Disbibulator', NULL, '2012-11-18', 12.50, 0),

(89, 'Bishbosher', 'Orange', '2008-05-23', 109.99, 1),

(101, 'Jambasher', 'Yellow', '2001-03-03', 3.99, 0)

-- create PK/clustered index with padding/fill factor

GO

/****** Object: Index [ix_pk_productId] Script Date: 12/10/2012 11:51:43 AM ******/

ALTER TABLE [test].[TableWithIndexes] ADD CONSTRAINT [ix_pk_productId] PRIMARY KEY CLUSTERED

(

[productId] ASC

)WITH (PAD_INDEX = ON, FILLFACTOR=90, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO