The following table summarizes support for all SQL Server property editors, and shows which editors are available to you by SQL Server version.
Note: Support is not provided for any password or encryption key information in the model.
|
Object Type |
SQL Server 2000 |
SQL Server 2005 |
SQL Server 2008 |
|
Aggregate |
No |
Yes |
Yes |
|
Application Role |
No |
Yes |
Yes |
|
Assembly |
No |
Yes |
Yes |
|
Asymmetric Key |
No |
Yes |
Yes |
|
Certificate |
No |
Yes |
Yes |
|
Credential |
No |
Yes |
Yes |
|
Cryptographic Provider |
No |
No |
Yes |
|
Database |
No |
Yes |
Yes |
|
Database Audit Specification |
No |
No |
Yes |
|
Database Encryption Key |
No |
No |
Yes |
|
Database Role |
No |
Yes |
Yes |
|
Database Triggers |
No |
Yes |
Yes |
|
File |
No |
Yes |
Yes |
|
Filegroup (Database) |
Yes |
Yes |
Yes |
|
FullText Catalog |
No |
Yes |
Yes |
|
FullText Index |
No |
Yes |
Yes |
|
FullText Stoplist |
No |
No |
Yes |
|
Function |
No |
Yes |
Yes |
|
Login |
No |
Yes |
Yes |
|
Partition Function |
No |
Yes |
Yes |
|
Partition Scheme |
No |
Yes |
Yes |
|
Physical File |
No |
Yes |
Yes |
|
Permission |
No |
Yes |
Yes |
|
Schema |
No |
Yes |
Yes |
|
Script Template |
Yes |
Yes |
Yes |
|
Server Audit |
No |
No |
Yes |
|
Server Audit Specification |
No |
No |
Yes |
|
Server Triggers |
No |
Yes |
Yes |
|
Spatial Index |
No |
No |
Yes |
|
Stored Procedure |
Yes |
Yes |
Yes |
|
Symmetric Key |
No |
Yes |
Yes |
|
Synonym |
No |
Yes |
Yes |
|
Table |
Yes |
Yes |
Yes |
|
Table Index |
No |
Yes |
Yes |
|
Table Triggers |
Yes |
Yes |
Yes |
|
User Ids |
No |
Yes |
Yes |
|
View |
Yes |
Yes |
Yes |
|
View Index |
No |
Yes |
Yes |
|
View Triggers |
No |
Yes |
Yes |
|
Workload Group |
No |
No |
Yes |
|
XML Index |
No |
Yes |
Yes |
|
XML Schema Collection |
No |
Yes |
Yes |
|
Copyright © 2013 CA.
All rights reserved.
|
|