Share via

SMS Provider Field Length Restrictions in Configuration Manager

  • Article

 

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The SMS Provider, in System Center 2012 R2 Configuration Manager, 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:

  1. Open the properties of the SQL Server view to see which table and table columns it uses.

  2. 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

SMS Provider in Configuration Manager
Configuration Manager Schema