K'隨手記

以下是SQLSERVER 2008R2安裝以後內建的說明文件定義的保留字

SQL Server uses reserved keywords to define, manipulate, and add databases. Reserved keywords are part of the Transact-SQL grammar that is used by SQL Server to parse and understand Transact-SQL statements and batches.

SQL Server instance names cannot match a reserved keyword. Use the following table to ensure that reserved keywords are not used in SQL Server instance names.

當磁碟空間不足時，想將master資料庫遷移預設的安裝路徑或變更錯誤訊息記錄檔位置，可依照下列步驟執行

 假設要將Master資料庫搬移到D:\SQLDATA2008，並將錯誤記錄檔路徑一併更改為D:\LOG\SQL2K8R2ERRORLOG

1.從功能選單中執行SQL Server Configration Manager

2.找到要修改的執行個體，例如:SQL Server(KSQL2008R2)按滑鼠右鍵後再執行停止(Stop)