I get the following sql error message when running the script in SQL Server 2000 Query Analyzer or 2005 SQL Server Management Studio Express.
Server: Msg 197, Level 15, State 1, Line 64
EXECUTE cannot be used as a source when inserting into a table variable.
Thanks,
Howard