Disable PRINT in SQL Server

Question

Hi,

I have a script with many debug messages, which are printed by PRINT function. Is there any way to disable that messages? I have in mind something like SET NOCOUNT ON, but for user messages.

Answer 1

You need to simply comment out all your PRINT statements

Answer 2

Quite simply, no. There is no #debug either.

SSMS tools pack has a #debug feature but I've not used it.

Answer 3

Sometimes the simplest solution is the best... Make all your print statements that deal with debugging as follows:

PRINT 'Debug ' + [WhateverStatementsYouDesire]

Then you can do a search and replace

PRINT 'Debug ' --> --PRINT 'Debug '

Do the opposite Find and Replace to turn them back on again...

(I do realize this is not quite what you were asking for but here is what I do for now. If there is such a switch as you are searching for I would probably change to that method.)

Answer 4

I like to set a variable, @Debug tinyint in my scripts/SPs.

Default/set this to 0 to suppress messages, 1 to show messages.

Then instead of using PRINT, use:

IF @Debug > 0 RAISERROR( 'Busy doing something...', 0, 1 ) WITH NOWAIT

Using WITH NOWAIT forces the message to be displayed immediately and not just when the output buffer is flushed.

As a convention, I use @Debug = 1 for progress messages, @Debug = 2 to include dynmaic SQL, @Debug = 3 to output result sets.

Of course if you have GO batch terminators in your script the variable method won't work.