Sql-server – How to suppress an informational raiserror message

error handlingsql server

I have a setup script that calls sp_configure a few times to set up some system variables, it works fine but I have a few of the following statement

Configuration option '%ls' changed from %ld to %ld. Run the RECONFIGURE statement to install.

with the variables filled in accordingly. Internally I can see sp_configure is calling

raiserror(15457,-1,-1, @configname, @prevvalue, @configvalue) with log

Is there anything I can do to prevent those informational messages (which are useless to the script, I call RECONFIGURE from inside the script) from displaying in the messages window in MSSMS when a user runs the script?

Best Answer

No. Informational messages cannot be suppressed.

Related Solutions

Sql-server – sp_executesql with user defined table type not behaving correctly

sp_executesql is for executing ad-hoc T-SQL. So you should try:

EXECUTE sp_executesql N'exec dbo.Repro @MetricData',N'@MetricData dbo.UDTT READONLY',@MetricData=@p3

Sql-server – sp_executesql adds statements to executed dynamic script

Prior to the sp_executesql you should see an sp_prepare statement in Profiler that would give more insight: http://msdn.microsoft.com/en-us/library/ff848808(v=sql.110).aspx

Sometimes this can be hard to find, but was made a bit easier with extended events in 2008R2 - specifically causality tracking.

http://msdn.microsoft.com/en-us/library/bb630284.aspx

Best Answer

Related Solutions

Sql-server – sp_executesql with user defined table type not behaving correctly

Sql-server – sp_executesql adds statements to executed dynamic script

Related Question