Make a reference key creatable in a manner friendly to MSSQL 2005.

ALTER TABLE dbo.MyTable WITH CHECK ADD CONSTRAINT
FK_MyTable_MyColumn FOREIGN KEY(MyColumn)
REFERENCES dbo.MyOtherTable (MyOtherColumn)