Hi,

I want to save Message printed in the Message tab when we run the TSQL.

I need something like

set @a= Messages printed below



Regards

When you execute the T-SQL script (-i option) with SQLCMD, you can capture results & messages mixed in an output file (-o  option).

SQLCMD tutorial: https://technet.microsoft.com/en-US/library/ms170207(v=SQL.105).aspx

If you only need the number of the rows from your query, you can use

@@ROWCOUNT

I want to Capture the Message to a variable within the TSQL script. SQLCMD, PowerShell and other utilities I'm aware.

I'm not particularly looking of the row count, I want to save a message to a variable irrespective of the TSQL Command.

>I want to save a message to a variable irrespective of the TSQL Command.

I am afraid that is not possible.

That message is not produced by SQL Server, but by the query tool. All that SQL Server produces is the number which it sends on the TDS stack.