They now use the VS2010 Shell. Whether that is an improvement is a matter of taste, I guess. But there is now an option so that new tabs are place rightmost. But the tab order is still messed up if a tab falls out of sight.
You now have the full power of customising the keyboard. But the customisation dialogue is just as difficult to use as it is in VS. And there is no built-in keyboard mapping for SQL 2000 anymore, which is bad.
If you like Intellisense, I think they claim to have improved it. (I don't use it, so I can't judge.)
There is a new "Profiler" that uses Extended Events, which is the new trace facility in SQL Server going forward. From a GUI perspective, the Extended Events node is more difficult to use I think, but that is also because X-Events are more powerful. There is a learning curve. Profiler is still there, but since SQL Trace is deprecated, there are no enhancement to it.
There is also support for AlwaysOn, the new HA/DR features in SQL 2012.
The big news on the tool side is SQL Server Data Tools, an add-in to Visual Studio with a powerful T-SQL Editor. It will require you to work in a certain way, but it can help you find many errors that you else would not have found until run-time because of deferred named resolution.
Erland Sommarskog, SQL Server MVP, email@example.comFriday, January 13, 2012 10:43 PM
Please go through this blog it lists all the enhancements in SSMS 2012
We have debugging enhancement in SSMS 2012 mostly all the features available for .NET developers.go through this for debugging
we have intellisense enhancements in 2012.please through this blog for intellisense
PLEASE MARK AS ANSWERED OR VOTE AS HELPFUL IF IT RESOLVES.
s dhwaniSunday, February 12, 2012 2:37 AM