How to aviod sql messages in text file

Hi All
I want to know how I can hide sql messages and other stuff in sql query. "SET nocount on" only remove row count messages. I want to remove after the colum header row gives ---------------- line, that one also need to aviod in text file. And also in sql code has some drop table commands. If those tables not in database it also generates messages something like "cannot drop the table". Please anyone advice me how aviod these messages as well as ------------------- line in text file.
Thank You
...