I got following error while compiling this x_TruncateTable proc:

Server: Msg 197, Level 15, State 1, Procedure x_TruncateTable, Line 126

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

plz clarify on this.I am executing it on sql server 2000.

thx