SMS Provider Field Length Restrictions in Configuration Manager
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
The SMS Provider, in Configuration Manager 2007, places restrictions on the width of character fields for schema classes. If you write a program that writes to these classes, you should take these field widths into account. Where they are used in the user interface, the Configuration Manager online Help provides the maximum character widths. You can also determine the width by dividing the corresponding schema class table column width by two to give the field width in characters.
You can determine the schema class table column width from the corresponding SQL Server views. For information about mapping schema classes to SQL Server views, see Configuration Manager Schema View Mapping. The steps for obtaining the table column width from the SQL Server view in Microsoft SQL Server are:
Open the properties of the SQL Server view to see which table and table columns it uses.
Open the corresponding table in the database tables view to discover the column width.
Classes that are commonly affected by this restriction are:
SMS_Package
SMS_Advertisement
SMS_Program
SMS_DistributionPoint
SMS_PDF_Package
SMS_PDF_Program
SMS_Query
SMS_Report
SMS_ReportDashboard
SMS_ReportViewSchema
SMS_CollectionRuleQuery
SMS_Collection
SMS_UserInstancePermissions
SMS_UserClassPermissions
SMS_UserInstancePermissionNames
SMS_UserClassPermissionNames
See Also
Concepts
SMS Provider in Configuration Manager
Configuration Manager Schema