Store SQL query message/Print Statement in file

Question

I want to store SQL Query Message into the File.

For Example: This is my query

Select Getdate()

The Result is:

2016-07-15 18:12:24.007

and the message is:

(1 row(s) affected)

I Want to store the message into file with extension.log

OR

How can I store Print Statement result in file. This will be helpful

Can anyone help me out this.

This has the solution you're looking for: sqlservercentral.com/Forums/Topic914307-391-1.aspx — MusicLovingIndianGirl
– MusicLovingIndianGirl, Commented Jul 18, 2016 at 6:08
...why do you want to do this? What problem are you trying to solve? Is there a specific table/column/statement you're interested in? Why not just log from the database? — Clockwork-Muse
– Clockwork-Muse, Commented Jul 18, 2016 at 6:13

Brian Leeming · Accepted Answer · 2016-07-15 12:58:33Z

1

In SQL Enterprise Manager, right click the T-SQL query window, select Results To then click Results to File.

answered Jul 15, 2016 at 12:58

Brian Leeming

11.8k8 gold badges35 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yes, but this is to store query result not message. I want to store only message.