Re: PRINT command
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 12/10/04
- Next message: Tibor Karaszi: "Re: CREATE VIEW"
- Previous message: Tibor Karaszi: "Re: xp_sprintf"
- In reply to: CB: "PRINT command"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Dec 2004 12:02:42 +0100
Use RAISERROR with the NOWAIT option instead of PRINT. It will generally flush the output buffer.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "CB" <craig.bryden@derivco.com> wrote in message news:e2HyFgp3EHA.3000@TK2MSFTNGP15.phx.gbl... > Hi > > I am using the PRINT command in a script. My problem is that the messages > are only being displayed when the entire script is complete. Is there a way > to get it to display immediately when the command has been processed? > > This seems to work with a lot of the system stored procedures (e.g. > sp_UpdateStats) > > Any help will be appreciated > > Thanks > > Craig > >
- Next message: Tibor Karaszi: "Re: CREATE VIEW"
- Previous message: Tibor Karaszi: "Re: xp_sprintf"
- In reply to: CB: "PRINT command"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|