HPSIM Reporting SQL OUTPUT

[Annette Jones_2]

Anyone know MSSQL2000 for Windows, I thought I would create a report for capacity management, cut and paste the sql output into MSSQL2000 query analyzer, which works fine. However I need the output of the sql statement to write to a file so that it can be collected on a daily basis.

Any idea's on how to output to a file?

ta

[Rob Buxton]

I use the osql utility. Not sure where it comes from, but it has a number of qualifiers among them an input for the SQL Statement and an output for, well the output!
There's also isql, but it's not quite as powerful as osql.

But, SQL does not naturally provide a neat display. You'll need to format the output.

[Aravindh Rajaram · Accepted solution]

Go to Query Analyzer and then press Ctrl+Shift+F

Then execute the query. Now you'll get the save dialog box to store the output of the query on to a file.

To get the results in the grid (on the query analyzer itself) press Ctrl+D and then execute the query.