Managing Server Settings

You use the Advanced page of the Server Properties dialog box to configure many server settings. As shown in Figure 6-6, you can set the default language, general server behavior, and other options on this page.

General server settings options on the Advanced page.

Figure 6-6. General server settings options on the Advanced page.

Enabling or Disabling File Streaming Support

When file streaming is enabled, SQL Server Database Engine can work with binary large objects (BLOBs) that are stored outside the database. At the server level, you control whether and how file streaming can be used using the Filestream Access Level setting, which by default is set to Disabled. When file streaming ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.