Management Studio is that it can generate a

Management Studio is that it can generate a script for most activities on the database that can be leveraged in future database administration and maintenance functions. Within the SQL Server Management Studio, you can work with the underlying subject matter databases, compose queries to review data, work with Analysis Manager cubes, compose data transformation processing, and interface with notification services, in addition to managing reports. This is an ideal interface for a developer, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities. If you right-click the Home folder, you see several options in the menu bar. You can delete a folder, create new folders, add new data sources, or import new files. You can also open a folder to see its contents by clicking the link to that folder (see Figure 12-2). You can also move folders other than the home page and rename folders under the Home folder. You can maintain the site settings for Reporting Services by right-clicking the Report Server name in the Object Explorer and selecting the Properties menu item from the list that appears. This will show the General tab of the Server Properties window. If you would like to enable a nice feature of allowing a My Reports folder for each user, simply select the check box for this option and select a role to apply to each user folder. (My Reports role will suffice. This is covered in more detail in Chapter 13.) The dialog box appears similar to that shown in Figure 12-3. Figure 12-2: The menu on the Home folder in the SQL Server Management Studio showing all the maintenance options. Chapter 12: Managing and Administering Your Reports 229

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Bookmark the permalink.

Comments are closed.