SMS Provider Field Length Restrictions in Configuration Manager

  • Article

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:

  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

Concepts

SMS Provider in Configuration Manager
Configuration Manager Schema