SQL: Turning off completion times in SQL Server Management Studio (SSMS)

Once again today, I was asked by a developer, how you can "turn off those annoying completion time messages in SSMS".

A few releases of SQL Server Management Studio (SSMS) back, the product team decided that we'd all like completion times shown in the Messages output tab. I don't share their enthusiasm for them.

For a start, a completion time was already shown here in the Properties window for the query, along with much more info:

So it really was quite irrelevant. Worse, I often use the output of the Messages tab as text for scripts, etc. The last thing I wanted were a bunch of completion times sprinkled through those.

Initially, you couldn't turn it off either. Fortunately, the team listened to us all complaining about it, and they fixed it.

Single Query Window

If you want to disable these messages for a single query window, you can do it here from the Query menu, then Query Options, then Advanced.

 

As the Default

If you want this disabled by default, you can do that from the Tools menu, then Options, then Query Execution, then SQL Server, then Advanced:

And say goodbye to those messages.

 

 

2 thoughts on “SQL: Turning off completion times in SQL Server Management Studio (SSMS)”

  1. Helpful and useful, thanks

    I always wished they would optionally just output the extra text either prepended with — on each line or wrapped with /* */

    1. Hi Robert, thanks, glad it helped. I agree conceptually with the dashes option, but most of the time, I don't want it mixed with the output at all.

Leave a Reply

Your email address will not be published. Required fields are marked *