Quick Check

1.Which edition of SQL Server supports installing more than one instance of SQL

2. What are the authentication modes that SQL Server can be confi gured with?

Quick Check Answers

1. Only SQL Server Enterprise supports multiple instances on the same machine.

2. You can confi gure SQL Server to operate under either Windows Only or Windows

#1 Install the AdventureWorks Sample Database

EXEC sp_configure 'filestream_access_level', 2;GORECONFIGUREGORESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\Microsoft SQLServer\100\Tools\Samples\AdventureWorks2008.bak' WITH RECOVERY;GORESTORE DATABASE AdventureWorksDW FROM DISK='C:\Program Files\MicrosoftSQL Server\100\Tools\Samples\AdventureWorksDW2008.bak' WITH RECOVERY;GO

2）为数据库实例启用FILESTREAM（文件流）

EXEC sp_configure filestream_access_level,2RECONFIGURE

 Quick Check

1. What are the two basic components of Database Mail?

2. What are the two types of mail profi les that can be created?

Quick Check Answers

1. Database Mail uses mail profi les which can contain one or more mail accounts.

2. Mail profi les can be confi gured as either public or private.

Enable the Database Mail feature:

EXEC sp_configure 'show advanced options', 1;GORECONFIGURE;GOEXEC sp_configure 'Database Mail XPs', 1;GORECONFIGURE WITH OVERRIDEGO