SQL SERVER Management Studio – Removing Completion Time in Messages

Earlier, I wrote a blog post about SQL SERVER Management Studio – Completion Time in Messages. This was newly introduced in the recent version of SQL Server Management Studio. Since the blog post, I have received many curious emails and questions while working with a client on Comprehensive Database Performance Health Check about Removing Completion Time in Messages.

I have researched a bit on SSMS and asked a few friends but I could not find the answer to this one. I am super glad that SQL Server Expert Oz, just posted a comment with a link to StackOverflow solution for Removing Completion Time in Messages.

The option to hide Completion Time in Messages is added in SQL Server Management Studio 18.3 and later version.

Go to Tools > Options > Query Execution > SQL Server > Advanced. Now uncheck the Show Completion Time checkbox.

Removing Completion

That’s it. It is that simple to disable the Completion Time in Messages.

Here are a few additional blog posts related to SQL Server Management Studio.

SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard
The latest release of SQL Server Management Studio (SSMS), requires a mention about it. The latest version contains a Performance Dashboard by default.

Install SQL Server Management Studio – SQL in Sixty Seconds #080
In the earlier version of SQL Server, while installing SQL Server Engine, SQL Server Management Studio (SSMS) was automatically installed along with the SQL Server Engine. Actually, the installation of SSMS was one of the features and was installed from the original media. This was very convenient most of the time when the user was installing SQL Server Engine for the first time and had media available along with him.

Database Diagram – Available Again in SQL Server Management Studio 18.1 Onwards
The good news is here when Microsoft has released new SQL Server Management Studio (SSMS) V 18.1, which now have Database Diagrams and a few other enhancements.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Exit mobile version