#眉標=SQL Server 2005
#副標=SQL Server 2005基礎入門
#大標=認識SQL 2005認證與熟悉SQL 2005系統架構
#作者=文／楊志強



==<box>===========
EXEC sp_configure
GO
--結果
name                                minimum     maximum     config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
allow updates                       0           1           0            0
clr enabled                         0           1           1            1
cross db ownership chaining         0           1           0            0
default language                    0           9999        28           28
max text repl size (B)              0           2147483647  65536        65536
nested triggers                     0           1           1            1
remote access                       0           1           1            1
remote admin connections            0           1           1            1
remote login timeout (s)            0           2147483647  20           20
remote proc trans                   0           1           0            0
remote query timeout (s)            0           2147483647  600          600
server trigger recursion            0           1           1            1
show advanced options               0           1           0            0
user options                        0           32767       0            0

==<end>==============



==<box>===========
--進行資料庫轉向
use master
go
--移除舊的本機伺服器名稱
sp_dropserver 'W2K3WIN'
go
--加入新的本機伺服器名稱，注意要指定local選項
sp_addserver   @server ='NEWWIN', @local='local'
go
--接著重新啟動SQL Server 執行個體
==<end>==============



==<box>===========
--簡易的資料庫建立陳述式
USE MASTER
GO
CREATE DATABASE SAMPLE
GO
--結果



==<box>===========
--建立範例資料庫
USE MASTER
GO
CREATE DATABASE [MYDB] ON  PRIMARY 
( NAME = N'MYDB_Prm', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MYDB_Prm.mdf' , SIZE = 4096KB ), 
 FILEGROUP [MyDB_FG1] 
( NAME = N'MyDB_FG_1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MyDB_FG_1.ndf' , SIZE = 1024KB ), 
( NAME = N'MyDB_FG_2', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MyDB_FG_2.ndf' , SIZE = 1024KB )
 LOG ON 
( NAME = N'MYDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MYDB.ldf' , SIZE = 1024KB )
GO
--結果
命令已順利完成。
==<end>==============