List Of Tables Used In Stored Procedure (edit)
SELECT
NAME as 'List Of Tables'
FROM SYSOBJECTS
WHERE ID IN ( SELECT SD.DEPID
FROM SYSOBJECTS SO,
SYSDEPENDS SD
WHERE SO.NAME = 'Sp_ListTables' ----name of stored procedures
AND SD.ID = SO.ID
)
SELECT
NAME as 'List Of Tables'
FROM SYSOBJECTS
WHERE ID IN ( SELECT SD.DEPID
FROM SYSOBJECTS SO,
SYSDEPENDS SD
WHERE SO.NAME = 'Sp_ListTables' ----name of stored procedures
AND SD.ID = SO.ID
)