Okay, corrected the code for SQL 2008 (at least this is what worked for me).

/* create the basic table structures needed */

CREATE TABLE [X_DIMENSION]

( [LOC] [int] NULL ,...