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
 Transact-SQL (2000)
 Suppressing OSQL Output

Author  Topic 

Shawn
Starting Member

9 Posts

Posted - 2002-05-01 : 15:03:29
I am running OSQL to process a script containing DDL and Stored Procedure definitions. During processing I get numerous examples of the form:

1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3>
4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6
> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 1> 2>


Is there some way to suppress this output leaving me with just the messages that are explicitly 'print'ed? I thought that some combination of the -n and -r parameters would do it for me, but either I am using them incorrectly or I have misunderstood their purpose.

Thanks.


Shawn
Starting Member

9 Posts

Posted - 2002-05-01 : 15:14:27
OK, never mind. Chalk it up to user error/stupidity. -n works just fine.

It's funny how publishing to the world immediately exposes ones shortcomings. :)

Go to Top of Page
   

- Advertisement -