find Table used in number of Stored procedures

SELECT
 DISTINCT so.name
             FROM syscomments sc 
INNER JOIN sysobjects so
 on sc.id=so.id WHERE 
sc.text LIKE '%TableName%'

SQL SERVER – Script/Function to Find Last Day of Month

DECLARE @date DATETIME
SET @date= getdate()
SELECT DATEADD(dd, -DAY(DATEADD(m,1,@date)), DATEADD(m,1,@date))