I Already tried with set fmt off,but still same error.

Is there any issue with global temp tables(the sp from sql 200 isntance)

i tried to execute in sql 2008 instane. is there any issue in doing this?

Thanks in advance