SQL Server 2012

  1. Specifies the action taken by the server upon encountering various types of errors during processing. These settings are ...
  2. Specifies the action taken by the server upon various types of errors during processing. These settings will be used as the ...
  3. Specifies the action taken by the server upon various types of errors during processing. This setting will be used as the ...
  4. Specifies the action taken by the server when there is a reference to a member that does not exist. This property applies ...
  5. Specifies the angle in degrees to rotate the title. If set to Auto, the angle depends on the docking placement. If not docked, ...
  6. Specifies the approximate number of distinct values in a column that the aggregation counts distinctly. Low indicates 500,000 ...
  7. Specifies the approximate number of group by keys that the aggregation produces. Low indicates 500,000 key values, Medium ...
  8. Specifies the behavior of the Distribution Agent when a conflict is detected. By default, the Distribution Agent will stop ...
  9. Specifies the caption for the unknown member in the default language. If not specified, the default value "Unknown" is used. ...
  10. Specifies the column containing the exclusion terms. The column must be in the table specified in the property OutTermTable. ...
  11. Specifies the column that contains the reference terms. The column must be in the table specified in the property RefTermTable. ...
  12. Specifies the column type. The valid values are Canonical, ColumnSimilarity, KeyIn, KeyOut, PassThru, Similarity and Undefined. ...
  13. Specifies the condition under which the action will be available. If not specified, then the action is always available for ...
  14. Specifies the criteria by which members of the highest level (ignoring the (All) level, if any) are identified. This property ...
  15. Specifies the criteria used to match table and column names, and thereby heuristically determine the relationships between ...
  16. Specifies the current storage mode of the partition. This reflects the current state of the partition if the ProactiveCaching ...
  17. Specifies the data size used by Analysis Services. The data size specified for this property can differ from the data size ...
  18. Specifies the data type of the measure. For count and distinct count, this can be different from the data type defined on ...
  19. Specifies the data type used by Analysis Services. The data type specified for this property can differ from the data type ...
  20. Specifies the database against which an MDX query or DMX statement will execute. The database parameter is ignored when the ...
  21. Specifies the date that the object was last modified. This date does not reflect modifications to any major object contained ...
  22. Specifies the default language for the cube The names defined for the cube and its contained objects will be used as the ...
  23. Specifies the default language for the dimension. The names defined for the dimension and its subordinate objects are used ...
  24. Specifies the default language for the mining model. The names defined for the mining model and its subordinate objects are ...
  25. Specifies the default language for the mining structure. The names defined for the mining structure and its subordinate objects ...
  26. Specifies the default storage mode for the cube. This provides the default for new measure groups and partitions created ...
  27. Specifies the definition of how levels in a parent-child hierarchy are named (for example "CEO ; VP "). If not specified, ...
  28. Specifies the details of the binding to a column that contains the number of levels between a member and its parent. Only ...
  29. Specifies the details of the binding to a column that provides unary operators to control how attribute members are aggregated ...
  30. Specifies the distance between the end of the gauge and the end of the scale, as a percentage of the size of the gauge (height ...
  31. Specifies the distance between the start of the gauge and the start of the scale, as a percentage of the size of the gauge ...
  32. Specifies the distance from the tip of the pointer to the scale, measured in percentage of the size of the gauge (height ...
  33. Specifies the estimated number of rows in a partition using the aggregation design. This value was used by the Aggregation ...
  34. Specifies the estimated number of rows in the fact tables. This is the estimated rows per partition, and provides the default ...
  35. Specifies the estimated number of rows in the fact tables. This is the estimated rows per partition, and provides the default ...
  36. Specifies the exact number of distinct values in a column that the aggregation counts distinctly. If a CountDistinctScale ...
  37. Specifies the exact number of group by keys that the aggregation produces. If a KeyScale value is specified, the value in ...
  38. Specifies the existence of an unknown member, and whether that member is visible or hidden. Fact data not associated with ...
  39. Specifies the expression to use to group the data for dynamic Tablix members. Group expressions cannot be used if any ancestor ...
  40. Specifies the file format for the TraceFile parameter (if this parameter is specified). The available options are text or ...
  41. Specifies the file used to collect rows that have formatting errors. These rows are copied into this error file "as is." ...
  42. Specifies the forecasting algorithm to use. Select MIXED to create models for both ARTXP and ARIMA time series algorithms ...
  43. Specifies the forecasting algorithm to use. Select MIXED to create models for both ARTXP and ARIMA time series algorithms ...
  44. Specifies the hint that causes similar rows that contain differing leading or trailing numeric values be less likely to be ...
  45. Specifies the identifier for any other dimension on which the current dimension depends. If set, this property indicates ...
  46. Specifies the identifier for the measure group to which the key performance indicator (KPI) is most strongly associated (for ...
  47. Specifies the identifier for the parent of the key performance indicator (KPI), allowing KPIs to be organized in a hierarchical ...
  48. Specifies the installation mode for the report server. Valid values include Default, DefaultSharePoint, and FilesOnly. The ...
  49. Specifies the installation mode for the report server. Valid values include DefaultSharePointMode, and SharePointFilesOnlyMode. ...
  50. Specifies the level of dimming for the map control when it doesn't have the focus.The value of this property must be in the ...
  51. Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. ...
  52. Specifies the lower constraint for any time series prediction. Predicted values will never be smaller than this constraint. ...
  53. Specifies the maximum amount of memory (MB) that this instance of the Fuzzy Lookup transformation can use. If 0 is given, ...
  54. Specifies the maximum amount of memory (MB) that transform should use. A value of 0 will enable dynamic memory usage based ...
  55. Specifies the maximum amount of time following receipt of a notification before creation of a new MOLAP cache commences, ...
  56. Specifies the maximum amount of time that can elapse between the creation of a MOLAP cache and the creation of the next MOLAP ...
  57. Specifies the maximum amount of time that the data sources must be free of transactions before the server starts creation ...
  58. Specifies the maximum number of attribute states that the algorithm supports. If the number of states that an attribute has ...
  59. Specifies the maximum number of cases in which an itemset can have support. If this value is less than one, it represents ...
  60. Specifies the maximum number of input attributes that the algorithm can handle before invoking feature selection. Setting ...
  61. Specifies the maximum number of input attributes that the algorithm can handle before invoking feature selection. Setting ...
  62. Specifies the maximum number of items allowed in an itemset. Setting this value to 0 specifies that there is no limit to ...
  63. Specifies the maximum number of itemsets to produce. If no number is specified, the algorithm generates all possible itemsets. ...
  64. Specifies the maximum number of key errors that can occur before either processing stops, or processing continues but key ...
  65. Specifies the maximum number of output attributes that the algorithm can handle before invoking feature selection. Setting ...
  66. Specifies the maximum number of states for a non-sequence attribute that the algorithm supports. If the number of states ...
  67. Specifies the maximum number of states that a sequence can have. Setting this value to a number greater than 100 can result ...
  68. Specifies the maximum number of syntax errors and compilation errors that can occur before the data copy operation is canceled. ...
  69. Specifies the maximum zoom for the map, in which the layer is visible. This property only applies when Visibility is set ...
  70. Specifies the measure used to resolve a Multidimensional Expressions (MDX) expression if a measure is not explicitly referenced ...
  71. Specifies the metadata cached for the linking object, as well as the behavior upon any changes to the underlying linked object. ...
  72. Specifies the method used to calculate the split score. The available methods are: Entropy (1), Bayesian with K2 Prior (3), ...
  73. Specifies the method used to discretize (group) the members of the attribute. The number of buckets created by discretizing ...
  74. Specifies the method used to fill the gaps in historical data. By default, irregular gaps or ragged edges in data are not ...
  75. Specifies the method used to fill the gaps in historical data. By default, irregular gaps or ragged edges in data are not ...