Sorry about the omissions....

USE [XXXX]

GO

/****** Object: StoredProcedure [dbo].[SP_XXXXX] Script Date: 07/22/2010 09:39:29 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SP_XXXXX]

...