#眉標=SQL Server 2008
#副標=SQL Server 2008功能初體驗（2）
#大標=SQL Server 2008宣告式管理架構
#作者=文／圖 楊志強


==<灰>===========
--建立測試資料庫
USE master
GO
CREATE DATABASE NEWDB
GO==<end>==============




==<灰>===========
--轉向資料庫
USE NEWDB
GO
--建立不符合tbl資料表
CREATE TABLE myStudent
(c1 int)
GO
--結果
Policy 'Enforce Table Name' has been violated by 'Server/Database[@Name='NEWDB']/Table[@Name='myStudent' and @Schema='dbo']'. This transaction will be rolled back.
Msg 3609, Level 16, State 1, Procedure sp_syspolicy_dispatch_event, Line 88
The transaction ended in the trigger. The batch has been aborted.
==<end>==============




==<灰>===========
--轉向資料庫
USE NEWDB
GO
--建立不符合tbl資料表
CREATE TABLE tblStudent
(c1 int)
GO
--結果
Command(s) completed successfully.==<end>==============


如果讀者有興趣可以造訪微軟SQL Server 2008的CTP網站，網址為https://connect.microsoft.com/sqlserver/content/content.aspx?contentid=5395。