This procdeure for dependany object

[AJITH123]

IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE NAME = 'cspPROCEDUREDEPENDANCY')
DROP PROCEDURE cspPROCEDUREDEPENDANCY
GO
/*Procedure will return the dependent objects list */
/* Creted By - Ajith */
CREATE PROCEDURE cspPROCEDUREDEPENDANCY @ProcedureName nvarchar(100)
AS
BEGIN
SELECT NAME [OBJECT NAME] FROM SYS.OBJECTS WHERE OBJECT_ID IN (
   SELECT REFERENCED_MAJOR_ID FROM SYS.SQL_DEPENDENCIES  WHERE OBJECT_ID = (
      SELECT OBJECT_ID FROM SYS.OBJECTS WHERE NAME = @ProcedureName  )
   )
END
/*Example */
/*
IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE NAME = 'Test_tab1')
DROP TABLE Test_tab1
GO
CREATE TABLE Test_tab1 (Id INT)
GO
IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE NAME = 'Test_tab2')
DROP TABLE Test_tab2
GO
CREATE TABLE Test_tab2 (Id INT)
GO

IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE NAME = 'Test_cspUseObjects')
DROP PROCEDURE Test_cspUseObjects
GO
CREATE PROCEDURE Test_cspUseObjects
AS
BEGIN
SELECT * FROM TEST_TAB1
SELECT * FROM TEST_TAB2
END
*/
/*
Exec cspPROCEDUREDEPENDANCY 'Test_cspUseObjects'
*/