tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P13

Microsoft SQL Server 2008 R2 Unleashed- P13:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 74 CHAPTER 4 SQL Server Management Studio schema that it belongs to or the date on which it was created. Again for those who deal with large databases and thousands of database objects this feature is very helpful. Administrators also find the enhanced scripting capabilities in the Object Explorer very useful. The scripting enhancements are centered mostly on the administrative dialog boxes. These dialogs now include a script button that allows you to see what SSMS is doing behind the scenes to effect your changes. In the past the Profiler could be used to gather this information but it was more time-consuming and less integrated than what is available now. Figure shows an example of an administrative dialog with the scripting options selected at the top. You can script the commands to a new query window a file the Windows Clipboard or a job that can be scheduled to run at a later time. FIGURE Scripting from administrative dialogs. Aside from these features many of the features and much of the functionality associated with the Object Explorer is similar to what was found in SQL Server 2000 and is almost identical to what was found in SQL Server 2005. Keep in mind that there are some additional nodes in the Object Explorer tree and that some of the objects are located in different places. For example the Management node now contains nodes for Policy Management Data Collection and the Resource Governor which are all new in SQL Server 2008. Download from Administration Tools 75 One often-overlooked Object Explorer feature is the reports option that was added in SQL Server 2005 and still exists in SQL Server 2008. This option is available by right-clicking on a node in the Object Explorer. Reports are not available for every node in the Object Explorer tree but many of them do have this option. Most reports are found in the toplevel nodes in the tree. For example if you right-click on a database in the Object Explorer tree and then select .