one clarification:

this is what I meant to say. You cannot use this construct to get the output of a stored procedure into a table variable.

declare @table_variable table(f1 varchar(100), f2 varchar(100))

INSERT INTO @table_variable EXEC sp_depends 'anyTableName'

Server: Msg 197, Level 15, State 1, Line 2

EXECUTE cannot be used as a source when inserting into a table variable.

sorry for the confusion.

jambu