find if table exists

SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mONTHLY'
AND TABLE_NAME ='table'

check if stored proc is exists

IF EXISTS (SELECT * FROM dbo.sysobjects 
WHERE id = object_id(N'[dbo].[your_procedure_name]') 
and OBJECTPROPERTY(id, N'IsProcedure') = 1)