Dynamic Sql: Truncate Table: Trap @@ERROR

Greeting All, I have a stored proc that dynamically truncates all the
tables in my databases. I use a cursor and some dynamic sql for this:


......
create cursor
Loop through sysobjects and get all table names in my database.

....
exec ('truncate table ' + @TableName)

Now, I want to be able to determine if an error occurred or not nad log
that error to a table in another database.

However, when I try to trap the value of @@ERROR after the
exec ('truncate table ' + @TableName) when an actual error occurs it
fails. My error was synthetically created by placing a foreign key on
the table which precludes the option of truncation:

Server: Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'MyTable' because it is being referenced by a
FOREIGN KEY constraint.

The actual relevant code snippet is:

BEGIN
BEGIN
SET @v_RowCount = (
SELECT rowcnt
FROM sysindexes
WHERE id = (
SELECT id
FROM sysobjects
WHERE name = @v_Name
)
AND indid IN (0,1)
)
EXEC('truncate table ' + @v_Name)
-- If there was an error truncating the current table.
-- Write the event to the MessageLog table.
IF (@@ERROR <> 0)
BEGIN
SET @v_OutputMessage = ('There was an error ' + @v_name)
INSERT INTO MessageLog (message) values (@v_outputmessage)
RETURN (-1)
END



Like I was saying, when the error is generated because of the foreign
key the variable @@error is never set to 4712, in fact if I were to put
a "select @@ERRROR" directly below the "exec('tru..')" statement it
would never be executed. The only thing that would show up in
Enterprise Manager would be the:

Server: Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'MyTable' because it is being referenced by a
FOREIGN KEY constraint.
Any ideas as to what is going on here?

Thanks, TFD.