Hello, All!
I have read in somewhere that I can disable the print information and error
message on the screen when I am running a script or transact-sql. Sorry, but
I reaaly don't remember if I read it in the Internet or in the SQL SErver
books on-line.
I don't remeber too, if i read it about osql command prompt ou about SQL
Query Analyzer.
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1You can disable the display of the rowcount via SET NOCOUNT ON.
HTH, Jens Suessmeyer.|||QA: Only option would be to suppress *all* results. You find the option for that in Tools, Options,
Results tab (Discard results).
OSQL: Use the -m switch. For instance -m25
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juliano H via SQLMonster.com" <u13014@.uwe> wrote in message news:5accb064068ae@.uwe...
> Hello, All!
> I have read in somewhere that I can disable the print information and error
> message on the screen when I am running a script or transact-sql. Sorry, but
> I reaaly don't remember if I read it in the Internet or in the SQL SErver
> books on-line.
> I don't remeber too, if i read it about osql command prompt ou about SQL
> Query Analyzer.
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment