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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 OSQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-06 : 21:08:19
Keith writes "I am using the OSQL command line utility to execute a query that is stored in a text file. The text file queries are built dynamically by the client application. There are currently about 180 queries (Text files) that will run on at a Month End. I would like to know if there is a way to determine whether an error occurred during the execution of the query. I know that you can write the output to a text file, however I only want to see the output for queries where an error was returned, and not for the queries that were executed succesfully. I would greatly appreciate any help that you can offer, be it with an OSQL, or any other command line utility. Thanking you in advance, Keith.
(SQL Server 7.0 - SP2, Windows NT 4.0 - SP 4)"
   

- Advertisement -