SMS Object Naming Size Limits (SQL versus MMC)
SMS 2.0 the limit in the MMC was something like 52 characters
| |
SQL SMS 2.0 |
MMCSMS 2003 SP3 |
SQL SMS 2003 SP3 |
SQL SMS 2003 SP2 |
| Collection |
255 |
128 |
255 |
255 |
| Package |
128 |
51 |
128 |
100 |
| Program |
100 |
51 |
100 |
100 |
| Advertisement |
200 |
101 |
200 |
200 |
Note: if you create it via WMI (command line, VB) your limit is the SQL table length. However if you then open that WMI created object, the MMC will require you to change the Name. Not a lot of consistency here.
BDD Package:Program
Default size is 50 char
This can be increased to 255 without any adverse effects.
Note: ANSI Nulls has no effect on or off