|
|
-
|
|
SQL Server 2012 (Denali) does not support 80 compatibility level. The database should be at least compatibility level 90...
|
|
-
|
|
SQL Server 2012 Denali discontinued support support for the following `RESTORE` options
1. RESTORE DATABASE WITH DBO_ONLY
2. RESTORE LOG WITH DBO_ONLY
...
|
|
-
|
|
The Active Directory Helper service and the related components has been removed from SQL Server 2012 (Denali). The following system stored procedures are not available any more.
1. `sp_ActiveDirectory_Obj`
2. `sp_ActiveDirectory_SCP`
3. `sp_ActiveDi...
|
|
-
|
|
Code snippets is one of the very important feature that has been added in SQL Server 2012 SSMS, which greatly improves productivity. In SQL Server 2012, now you can create your own snippets and insert that snippets in your queries/stored procedures by u...
|
|
-
|
|
We often use some external tools to manage our task list, where we will add our tasks and will follow the tasks according to the task list. Now with SQL Server 2012, external tool is no longer required.
SQL Server 2012 provides task list, where we can ...
|
|
-
|
|
Often in presentations, there is requirement of increasing size of content in SSMS. Until now, we used to use some third party softwares. Now SQL Server 2012 provides an option to increase/decrease the size.
We can individually configure the font-size ...
|
|
-
|
|
Until SQL Server 2012, in SSMS, we were able to open only one query window. 2 or more query windows can't share the same screen. Only one query window can be visible on the screen.
Now SQL Server 2012 SSMS provides the option to open multiple query win...
|
|
-
|
|
The default font in the query editor has been changed to Consolas in SQL Server Denali. Before denali, default font was Courier New....
|
|
-
|
|
Extended events provides very detailed information about, what is going inside in SQL Server. But before SQL Server 2012, there is not much UI support to create extended event sessions or configuring these sessions. There were some add-ins, which provid...
|
|
-
|
|
Before SQL Server 2012, SSMS already provided a feature to debug the queries. In SQL Server 2012, this has been enhanced more to provide more rich experience.
1. Conditional Hit breakpoints ? Break point will hit only when the specified condition met...
|
|