sql-serverssms-2012ssms-2014
SQL Server Management Studio: Display executed date/time on the status bar
When I execute a SQL query (e.g., SELECT 1) in SSMS, I can see the time it took to execute in the status bar. I would like to know whether it is possible to configure SSMS to show the date time the query was executed at (for example: Executed DateTime: 2015-07-28 11:15:30, not bothered about the date/time format) on status bar or in messages tab?
Here is the bar I am talking about with the section of interest enclosed in green rectangles.
Solution
I was looking for something similar, and found that if you hit F4, you can get this info (and more) from the Properties Window.
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Spark sending LIMIT to SQL Server on display function
- How can I manage Azure SQL user/login/credentials
- Can't add members to SSAS role through Visual Studio
- How to use Charindex for one or the other character
- SQL want to calculate time hours and mints of each emp
- Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Compute count(*) of unique occurrences into new column without group by in a single select query
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- How to get a list of tables with composite primary key in SQL Server?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
- What represents a double in sql server?
- Strange behavior of symfony doctrine during phpunit test - field becomes null in database
- Connecting SQL Server on Docker to Python
- Import multiple rows into a temp table in one round trip via SqlDataRecord
- How to find all trigger associated with a table with SQL Server?
- How to pass connection parameter "ApplicationIntent=ReadOnly" when using pymssql
- Incorrect syntax near ''
- SSRS Query execution failed for dataset
- Insert leading spaces, then the value to a varchar(10) column
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?