IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'emailCC'
      AND Object_ID = Object_ID(N'pal_Sales'))
BEGIN
    ALTER TABLE pal_Sales
	ADD emailCC VARCHAR(300)
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_GetSalesCcEmailAddresses]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_GetSalesCcEmailAddresses]
END




IF EXISTS ( SELECT * 
            FROM   sysobjects 
            WHERE  id = object_id(N'[dbo].[sp_GetSalesPrimaryContact]') 
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[sp_GetSalesPrimaryContact]
END




IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'notesStatements'
      AND Object_ID = Object_ID(N'pal_Setup'))
BEGIN
    ALTER TABLE pal_Setup
	ADD notesStatements VARCHAR(MAX)
END