I created the table, alter the sp, then start the service again, then run this command in SQL management studio:

select * from dbo.DebugSproc_T

but do not see any result (no row return) which I guess the service did not call the sp at all, and did not provide any error message!!!

Again, if I run the same codes in window form appl. it successfully generates the file.

Please help and greatly appreciate your patience!