使用 SQL 2008/ SQL 2008 R2 Management Studio 在修改資料表時, 總是得到以下的錯誤訊息
明明都把自己加入到 serveradmin, sysadmin…等admin 中了, 可是還是得到一樣的錯誤訊息,
因為 在 SQL management studio 中的一個防呆選項要先拿掉:『Pervent saving changes that require table re-creation』
Enjoy.
目前分類：SQL 2008 R2 (2)
- May 17 Mon 2010 15:15
SQL 2008/ SQL 2008 R2 Mangement Studio 防止修改資料表的選項
- Aug 25 Tue 2009 22:23
Microsoft SQL Server 2008 R2 August CTP
SQL Server® 2008 R2 expands on the value delivered in SQL Server® 2008 to help your organization scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will empower end users to access, integrate, analyze and share information using business intelligence tools they already know - Microsoft® Office.
The Microsoft® SQL Server® 2008 R2 August Community Technology Preview (CTP) includes Application and Multi-server Management which will help organizations manage database environments efficiently at scale with increased visibility and control across the application lifecycle. Also included is Report Builder 3.0 with support for geospatial visualization (mapping, routing, custom shapes) which can help produce new insights and discoveries well beyond what can be achieved with standard tables and charts when geospatial data is combined with business information. Microsoft® SQL Server® StreamInsight will also be made available for Community Technology Preview in the coming weeks. This new complex event processing technology will help businesses derive better insights by correlating event streams from multiple sources with near-zero latency.
Key features in this CTP release include:
- A new Control Point Explorer for central multi-instance and application utilization management.
- Built-in wizards to help you quickly set up and enroll instances and Data-Tier Application components into central management.
- Dashboard viewpoints for quick insight into application and instance utilization.
- Report Builder 3.0 with new support for geospatial visualization.
- StreamInsight core technology engine.
下載位置：
http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx
Enjoy.
