December 4, 2008 at 5:23 pm
When you run a query in the SSMS query window the only indication you have that the query is running or stopped is the small icon at the bottom of the screen.
This can lead to situations where the query has output some data, and you (in error) think that the query has ended, but it is actually still running.
This has caught me out one or twice.
My proposed solution to this is that Microsoft could add functionality where when you start to run your query the background colour of the results pane changes from white to light yellow. Then only when it completes it turns green. If the script fails with a syntax error or similar, it turns red. Other colours could indicate other things (such as server connection lost).
Do you think this is a good idea, and something that Microsoft could usefully add to the next version?
http://90.212.51.111 domain
December 5, 2008 at 1:31 am
Post it on Connect and see what the MS people say.
The info bar at the bottom of the screen does change colour (in SQL 2008) based on what server you're connected to, but only sometimes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply