SQL Server 2016

  1. To continue with setup for Reporting Services, you first need to install the .NET Framework 4.0. After doing so and restarting ...
  2. To continue, select a feature to install. If all features are already selected, these features are installed. You cannot ...
  3. To create a back-up copy of the report server encryption key: RSKeyMgmt -e -i -f -p To restore a back-up copy of the report ...
  4. To create a connection manager based on previously defined connection information, select a data connection, and then click ...
  5. To create a KPI based on a target measure, you must define a measure for the target of the KPI. You can also use an absolute ...
  6. To create a successful cache refresh plan, each dataset parameter value must conform to a specific format based on data type ...
  7. To create an availability group, you will need to: Specify an availability group name. Select one or more user databases ...
  8. To create and use an SSIS catalog, you must be a member of the SQL Server sysadmin fixed server role and have permissions ...
  9. To create permanent models on the server, users must be database administrators.{0}Granting a user database administration ...
  10. To debug this project, you must enable SQL/CLR debugging for the connection. Note that during debugging all managed threads ...
  11. To define time intelligence, you must define at least one hierarchy in the time dimension. This hierarchy must have at least ...
  12. To deploy your database you will need to: Have your Microsoft Azure SQL Database account information. Check the results of ...
  13. To design database diagrams or tables, you must install the SQL Server Service Pack. Run the Setup program for the SQL Server ...
  14. To design Integration Services packages in SQL Server Data Tools (SSDT), SSDT has to be installed by one of these editions ...
  15. To enable native compilation for this stored procedure, all tables accessed by this stored procedure must be memory-optimized ...
  16. To enable native compilation for this user defined function, all tables accessed by this user defined function must be memory-optimized ...
  17. To enable SSIS support AlwaysOn, you must be a member of the SQL Server sysadmin fixed server role and have permissions to ...
  18. To execute Integration Services packages in SQL Server Data Tools (SSDT), SSDT has to be installed by one of these editions ...
  19. To execute the DTS 2000 Package task, start SQL Server Setup and use the Advanced button from the Components to Install page ...
  20. To fail over to a new primary replica, you will need to: Select the secondary replica that will be the new primary replica. ...
  21. To failover to this replica, you will need to: Confirm this replica as the new primary replica. Review your selections. Check ...
  22. To find an Oracle Publisher, you must first connect to the SQL Server Distributor that has been configured to work with that ...
  23. To generate a new column encryption key, a column master key must be selected to protect it. The column master key is stored ...
  24. To get help for this message, you must send information across the Internet. Do you want to send the following information? ...
  25. To help you monitor your server, SQL Server provides a list of pre-configured event session templates you can select from, ...
  26. To import a BACPAC file, you must: Specify the BACPAC file to import. Specify import settings. Review the import summary. ...
  27. To import the data, confirm the source file format. Confirm that the file properties are correctly detected before proceeding. ...
  28. To issue ALTER DATABASE SET WITNESS, all three server instances must be interconnected, and the mirror database must be caught ...
  29. To join the scale-out deployment, connect to a report server that has already joined this scale-out deployment and accept ...
  30. To launch the Integration Services Deployment wizard, one of the components: Integration Services, Management Tools - Basic ...
  31. To launch the Integration Services SSISDB upgrade wizard, one of the components: Integration Services, Management Tools - ...
  32. To manage Error and Usage Reporting attributes, you must be a member of the local admin group. To proceed, logon with administrator ...
  33. To modify the priority of a subscription, run sp_changemergesubscription at the Publisher instead of using sp_changemergepullsubscription ...
  34. To move or copy the database using the detach and attach method, the Copy Database Wizard requires access to the source database ...
  35. To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command ...
  36. To operate database mirroring in synchronous mode with automatic failover, you must configure a witness server instance to ...
  37. To perform cross-validation, select parameters, and then click Get Results. Cross-validation might take some time to complete, ...
  38. To perform data validation, the exchange type for the synchronization must allow both upload and download phases. Restart ...
  39. To preserve existing relationships, each of the following columns will have one or more of its properties (Data type, Length, ...
  40. To prevent any potential data loss issues, you should review this script in detail before running it outside the context ...
  41. To prevent unauthorized access to the IIS server, always use SSL encryption with Basic authentication. For more information, ...
  42. To protect data definition language (DDL) statements that may contain passwords and other sensitive information, set the ...
  43. To protect your SQL Server database credentials, we will generate a database master key (DMK). Provide a strong password ...
  44. To publish this item as a new report part, it will be assigned a new, unique ID. You will no longer be able to use this item ...
  45. To re-provision the existing integration between this SharePoint environment and SQL Server Reporting Services, specify the ...
  46. To register a mirrored database in the monitor, select the principal or mirror server instance, and then set the Register ...
  47. To register the report server with Power BI, a URL to access Web Portal must be configured. Configure a URL on the "Web Portal ...
  48. To remove the update from the selected shared features, all instances that have the same update must be selected. Therefore, ...
  49. To rename the database, in Solution Explorer, right-click the project, and then click Properties. In the Property Pages dialog ...
  50. To restore the encryption key, click the Restore button. You must know the password that was used to protect the encryption ...
  51. To restore the master database, the server must be running in single-user mode. For information on starting in single-user ...
  52. To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, ...
  53. To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, ...
  54. To send e-mail, user {0} must be added to the DatabaseMailUserRole in msdb database. Do you want to add {0} to DatabaseMailUserRole? ...
  55. To set the filter on this column, it must be included in the Analysis Services trace. Add the column to at least one event ...
  56. To set the security for a Queue Reader Agent, click the properties button (.) for the distribution database associated with ...
  57. To share MDS data with other systems, create subscription views. Subscription views are SQL views in the MDS database that ...
  58. To simultaneously commit changes, the Subscriber connects to the Publisher, and the commit occurs at both servers. To queue ...
  59. To specify the column that contains the formula, select an attribute. To change a column, click the browse (.) button next ...
  60. To start mirroring this database, SQL Server must close all other connections to the database. Are you sure you want to start ...
  61. To start monitoring an Oracle Publisher, identify the SQL Server Distributor for that Publisher in the following dialog box. ...
  62. To support SQL Server multi-subnet failover clustering, you must select at least one valid IP address for every subnet in ...
  63. To synchronize a subscription using Web synchronization, both upload and download phases must be enabled. Specify ExchangeType ...
  64. To upgrade a full-text catalog, click Add Catalog, and locate and select it. Full-text indexes will be {0}, based on the ...
  65. To upgrade SharePoint integrated mode, the Reporting Services Windows service must be running. Use the Reporting Services ...
  66. To use report server e-mail, specify an existing SMTP server and an e-mail account that can send e-mail from that server. ...
  67. To use the detach and attach method, the SQL Server Agent job must run under an Integration Services Proxy account that can ...
  68. To view this summary, click the Refresh button in the Object Explorer toolbar, or select another object in Object Explorer. ...
  69. Tokenization cannot be enabled for attribute '%{property/}' in dimension '%{dimension/}' since server is not running in Tabular ...
  70. Too few array elements were found when parsing a property of type array. The elementCount is more than the number of array ...
  71. Too many '{0}' shared access policy identifiers provided. Server does not support setting more than '{1}' on a single container. ...
  72. Too many array elements were found when parsing a property of type array. The elementCount is less than the number of array ...
  73. Too many errors found (%1!s!) for object ID %2!s!. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS". ...
  74. Too many failed login attempts. This account has been temporarily locked as a precaution against password guessing. A system ...
  75. Too many Filestream containers were specified for Filestream Filegroup '%1!s!'. Specifying more than one Filestream Container ...