Please allow me to further explain my concern here:

The SQL script i posted here is extracted from an existing stored procedure of my system using SQL2000 and it is working fine without return an error. I just upgrade my server to SQL 2005 and error return.

I am thinking that we have so many stored procedure in system, how can i know which stored procedure will works fine in sql2000 but return this kind of error in SQL2005 as well?

So i am looking for a way to bypass this truncate error at database or server level instead of stored procedure.

Please advice. Thanks.