thanks for the query... but both the techniques fail for sp_spaceused 🙁

in the stored proc. i added something like...

CREATE PROCEDURE dbo.Tmp_SPGetAddress

AS

begin

exec sp_spaceused

end

GO

i am able to execute the above stored proc successfully... but when i use the same in the 2 techniques, it fails...