SQL Server 2016

  1. Specifies whether the project should start 64 bit SSIS runtime. If 64 bit SSIS runtime is not installed, this setting is ...
  2. Specifies whether the upgraded nodes should take ownership of the failover instance group or not. Use 0 to retain ownership ...
  3. Specifies whether to replace or append to existing data. Integration Services applies this property only if the CopyData ...
  4. Specifies whether to use the SqlBulkCopy interface to improve the performance of bulk insert operations. Only certain providers ...
  5. Specifies which account the report server NT service should execute under. When omitted or when the value is empty string, ...
  6. Specifies which account to use to access the exisiting report server catalog database during the upgrade. When omitted or ...
  7. Specifies which clustering method the algorithm uses The available clustering methods are: Scalable EM (1), Non-scalable ...
  8. Specifies which values are hidden for this hierarchy. This property supports ragged hierarchies containing logical gaps between ...
  9. Specifiies whether a Default Native or SharePoint install can be performed or not. true - If SQL Server Engine is installed ...
  10. Specify a command or query that returns a list of recipients and optionally returns fields used to vary delivery settings ...
  11. Specify a connection manager, data source, or data source view for the Excel destination. Then, select the mode used to access ...
  12. Specify a connection manager, data source, or data source view for the Excel source. Then, select the mode used to access ...
  13. Specify a connection manager, data source, or data source view, and select the table or the view into which the data is copied. ...
  14. Specify a data source and a query that returns a list of recipients and optionally returns fields used to vary delivery settings ...
  15. Specify a data source to use. You can select a table in a Data Source View, a table in a database connection, or the results ...
  16. Specify a data source to use. You can select a table in a data source view, a table in a database connection, or the results ...
  17. Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express ...
  18. Specify a filter on one table, and SQL Server will use defined relationships to add joins that extend this filter to other ...
  19. Specify a local or remote instance of SQL Server Database Engine. Then specify credentials that have permission to connect ...
  20. Specify a name for the SQL Server cluster resource group. The cluster resource group is where SQL Server failover cluster ...
  21. Specify a network name for the new SQL Server failover cluster. This will be the name used to identify your failover cluster ...
  22. Specify a new name for the server instance. If this will be the default instance, leave the New instance name blank. Learn ...
  23. Specify a strong password for the account. A strong password is at least 8 characters and includes a combination of upper ...
  24. Specify a temporary location for backup files. The location must be read and write accessible to the local operation, and ...
  25. Specify a valid name. The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the ...
  26. Specify a Web Application to be associated to and provisioned for access by this SQL Server Reporting Services Service Application. ...
  27. Specify additional IP addresses that are available and valid on the current node and subnet (previously-configured SQL Server ...
  28. Specify an ADO.NET connection manager, a data source, or a data source view, and select the data access mode. After selecting ...
  29. Specify an instance ID for Analysis Services. This value is used only for repair or remove scenarios for unfinished instances ...
  30. Specify an instance ID for Reporting Services. This value is used only for repair or remove scenarios for unfinished instances ...
  31. Specify an instance ID for SQL Server Database Services. This value is used only for repair or remove scenarios for unfinished ...
  32. Specify an OLE DB connection manager, a data source, or a data source view, and select the data access mode. If using the ...
  33. Specify an OLE DB connection manager, a data source, or a data source view, and select the data access mode. If using the ...
  34. Specify chart area name inside which the legend is drawn. Legend Position must be set to 'Auto' for this property to work. ...
  35. Specify DAX expressions that return Boolean values. Only rows that match the specified filters are visible to users in this ...
  36. Specify Evaluation Edition of StreamInsight or provide a product key to validate this instance of StreamInsight. To specify ...
  37. Specify how row-level errors are handled by this component. You can handle errors in the row, or truncation errors in columns. ...
  38. Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or ...
  39. Specify new labels for the data labels you want to change by typing the new label or selecting a new value from the New Labels ...
  40. Specify options used to address and fill in the e-mail message. Use the @ReportName and @ExecutionTime variables to return ...
  41. Specify parameter values for the Microsoft Association Rules algorithm used in the Shopping Basket Analysis task. Minimum ...
  42. Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False ...
  43. Specify that when a package cannot be upgraded, the SSIS Package Upgrade Wizard continues to upgrade the remaining packages ...
  44. Specify the account used to access the existing report server catalog database. This value is required. If you omit this ...
  45. Specify the amount of disk space used by the service application to store cached files. If this limit is exceeded, the PowerPivot ...
  46. Specify the columns, measures, and field ordering that define the default field set when visualizing this table in certain ...
  47. Specify the conditions used to direct input rows to specific outputs. If an input row matches no condition, the row is directed ...
  48. Specify the costs and profits associated with correctly and incorrectly predicting '{0}'. These costs/profits are needed ...
  49. Specify the credentials of a user who is a member of the Administrator group on the computer that hosts the report server. ...
  50. Specify the credentials of an existing account that the report server will use to connect to the report server database. ...
  51. Specify the credentials used by the Analysis Services server to connect to the data source when importing and processing ...
  52. Specify the credentials used by the Analysis Services server to connect to the data source. These credentials are used by ...
  53. Specify the data source views in which to generate the schema and Integration Services project for the generated packages. ...
  54. Specify the DirectQuery partition. The SQL Statement for the partition is used to query the data source when the model is ...
  55. Specify the domain or machine account under which the Distribution Agent process will run when synchronizing this subscription. ...
  56. Specify the expressions used to create new column values, and indicate whether the values update existing columns or populate ...
  57. Specify the ID for the instance of SQL Server that you are preparing. You need to specify the instance name during the Complete ...
  58. Specify the information that you would like to automatically send to Microsoft to improve future releases of SQL Server. ...
  59. Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, ...
  60. Specify the interval (in hours) to collect metrics on CPU usage, memory usage, and user connections. By default, the system ...
  61. Specify the interval (in hours) to count load and connection events for calculating the load-to-connection ratio. By default, ...
  62. Specify the location of a BI Semantic Model. For PowerPivot workbooks, enter a complete URL to a workbook hosted in a SharePoint ...
  63. Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, ...
  64. Specify the login used by a Subscriber to connect to the Publisher when simultaneously committing changes to replicated data. ...
  65. Specify the maximum data that can be added to a replicated column in a single INSERT, UPDATE, WRITETEXT, or UPDATETEXT statement. ...
  66. Specify the Microsoft Azure Virtual Machine that will host your database, or provide the name to create a new VM. To edit ...
  67. Specify the name and location of a file that will contain the copy of the key. You must specify a password that is used to ...
  68. Specify the name of the instance of SQL Server and the name of the database that will be deployed to the Microsoft Azure ...
  69. Specify the name of the instance of SQL Server or the Microsoft Azure SQL Database server that will host the deployed database, ...
  70. Specify the name, application pool, database, and default for this PowerPivot Service Application. To modify editable settings ...
  71. Specify the number of consecutive failures after which a data refresh schedule is disabled. Specify 0 to never disable a ...
  72. Specify the number of data files. The default is {0} for Express. This can be increased up to {1} or the number of cores, ...
  73. Specify the number of data files. The default is {0} or the number of cores, whichever is lower. This can be increased up ...
  74. Specify the number of data refresh cycles to check for inactivity. If a workbook has not been accessed by an interactive ...
  75. Specify the number of hours after which an inactive PowerPivot database is deleted from the cache. This value must be greater ...