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




IF EXISTS ( SELECT * 
			FROM sys.indexes 
			WHERE name='IX_SurfaceFieldData_surfaceFieldValueNum' 
			AND object_id = OBJECT_ID(N'[dbo].[pal_SurfaceFieldData]') )
BEGIN
	DROP INDEX IX_SurfaceFieldData_surfaceFieldValueNum ON [dbo].[pal_SurfaceFieldData]
END




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

