output the results of a query into a file 1

[pavithra123]

Hi, I am new to SQL server. I need to redirect the output of a query into a text file. I did not find anything on SPOOL ( as in Oracle ) so please any help would be appreciated.

Best Regards
Prem

 

[tlbroadbent]

Check the SQL Server FAQ at...

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14379

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[pavithra123]

Hi Terry,

Thanks a lot. I need more automation on this Which I 'll do it myself