Instead of using Client Server and its Query Analyzer to run SQL statements on a remote MS SQL Server 7 database, I find it easier to use osql on the command line.

I have installed a Unix-to-NT environment on my Client Server so now I can put the osql statements in a korn shell wrapper and output the results to an ASCII file. Now I have the full range of Unix commands to massage the data and create reports.

I am using this method, for example, to monitor the download of software to 1900+ clients.

For More Information

• What do you think about this tip? E-mail us at editor@searchDatabase.com with your feedback.
• The Best SQL Server Web Links: tips, tutorials, and much more.
• Have another SQL Server tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
• Do you have any technical questions about SQL Server administration or development? Post them--or help out your peers by answering them--in our live discussion forums.
• Check out our new Ask the Experts feature! Our SQL Server gurus are waiting to answer your toughest SQL Server questions.