Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-27 : 08:15:28
|
| Sean writes "We are having problems with an sending a result set to a file from Query Analyzer. Sometimes the file creates and sometimes it does not, although everytime we do get a successful file creation message with the correct file size. Sometimes we need to run ou queries5 or six times to finally have the file created.HAs anyone run into this before?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-27 : 08:17:18
|
| This is actually a better job for the osql command-line utility. You can save your query as a file (not the results, but the actual SQL statements) and then run osql to use that query and output the results to a file. You can even set it up to run automatically. Books Online has more details on "osql". |
 |
|
|
|
|
|
Query analyzer output problems