What is actual error is returned when TRUNCATE TABLE is run?

>Yes, I thought it would work from SQLEXEC but I am not having any success.
>
>
>hsql=SQLSTRINGCONNECT('dsn=ABC_NEW;uid=sa;pwd=xray')
>returns a positive connection number
>
>xEXEC= 'EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"'
>xxx=SQLEXEC(hsql,xEXEC)
>? xxx
>
>Works well and has a return XXX value of +1
>So NOCHECK is being activated as expected
>
>
>
>
>STORE UPPER(ALLTRIM(kill_tables.table)) TO m.table
>xaction="TRUNCATE TABLE "+m.table
>? xaction
>xx=SQLEXEC(hsql,xaction)
>? xx
>Always return -1 because of constraints defined in other user tables
>
>It seems that the nocheck on constraints just lasts for the one command that turns it off, but the
>constraints are BACK ON for next commaand.