SQL Server 2016

  1. Checks an instance of SQL Server having processors that are assigned with both the affinity mask and the affinity I/O mask ...
  2. Checks an instance of SQL Server having processors that are assigned with both the affinity64 mask and the affinity64 I/O ...
  3. Checks for default surface area settings for Analysis Services features. Only the features required by your application should ...
  4. Checks for default surface area settings for Database Engine 2005 and 2000 features. Only the features required by your application ...
  5. Checks for default surface area settings for Database Engine 2008 features. Only the features required by your application ...
  6. Checks for default surface area settings for Reporting Services 2005 features that can be accessed by using WMI. Only the ...
  7. Checks for default surface area settings for Reporting Services 2008 features that can be accessed by using WMI. Only the ...
  8. Checks for disabled Simple Object Access Protocol(SOAP) endpoints on the instance of SQL Server. Native XML Web Services ...
  9. Checks for stopped Service Broker endpoint on the instance of SQL Server. Service Broker provides queuing and reliable messaging ...
  10. Checks for user-created symmetric keys in the master database, which is not recommended. The master database contains the ...
  11. Checks for user-created symmetric keys in the msdb, model, and tempdb databases. This is not recommended. This recommendation ...
  12. Checks for Windows Authentication. When possible, Microsoft recommends using Windows Authentication. Windows Authentication ...
  13. Checks if a computer restart is required because of broken fusion ATL. A pending restart can cause SQL Server Setup to fail. ...
  14. Checks if database and the backups are on separate backup devices. If they are on the same backup device, and the device ...
  15. Checks if Lock Pages In Memory feature was enabled by virtue of LPIM privilege and absence of TF 845 on amd64 installations ...
  16. Checks if permission to access the database is enabled for guest user. Remove access to the guest user if it is not required. ...
  17. Checks if the local computer is an owner of an online cluster group for a failover cluster instance that contains the SQL ...
  18. Checks if The Microsoft .NET Framework 4 Server Core is already installed on this computer or is available for installation. ...
  19. Checks if the MSCS cluster has been validated and if there are any warnings reported in the MSCS cluster validation report. ...
  20. Checks if the PAGE_VERIFY database option is not set to CHECKSUM to provide a high level of data-file integrity. When CHECKSUM ...
  21. Checks if the selected instance name is already used by an existing cluster-prepared or clustered instance on any cluster ...
  22. Checks if the SQL Server Database Engine is configured with a server collation that can be used by SharePoint for the Reporting ...
  23. Checks that only members of the sysadmins fixed server role can execute CmdExec and ActiveX Script job steps. Applies only ...
  24. Checks that symmetric keys with a length less than 128 bytes do not use the RC2 or RC4 encryption algorithm. The best practice ...
  25. Checks that the AUTO_ CLOSE option is off for SQL Server Standard and Enterprise Editions. When set to on, this option can ...
  26. Checks that the AUTO_SHRINK option is off for user databases on SQL Server Standard and Enterprise Editions. Frequently shrinking ...
  27. Checks the max degree of parallelism option for the optimal value to avoid unwanted resource consumption and performance ...
  28. Checks the max work threads server option for potentially incorrect settings of an instance of SQL Server 2005. Setting the ...
  29. Checks the max worker threads server option for potentially incorrect settings of an instance of SQL Server 2000 that is ...
  30. Checks the max worker threads server option for potentially incorrect settings of an instance of SQL Server 2000 that is ...
  31. Checks to see if the SQL Server edition upgrade path selected supports multi-subnet failover clusters. For more information ...
  32. Checks whether a database has recent backups. Scheduling regular backups is important for protecting your databases against ...
  33. Checks whether data and log files are placed on separate logical drives. Placing both data and log files on the same drive ...
  34. Checks whether default trace is turned on to collect information about configuration and DDL changes to the instance of SQL ...
  35. Checks whether enforce password expiration on SQL Server logins is enabled. Enforce password expiration should be enabled ...
  36. Checks whether for the value specified for network packet size server option is set to the optimal value of 8060 bytes. If ...
  37. Checks whether hotfix KB937444 is installed. This is required for FILESTREAM to work on a Windows Server 2003-based cluster. ...
  38. Checks whether lightweight pooling is disabled on the server. Setting lightweightpooling to 1 causes SQL Server to switch ...
  39. Checks whether Microsoft SQL Server Reporting Services SharePoint shared service is installed on the computer side by side ...
  40. Checks whether password policy enforcement on SQL Server logins is enabled. Password policy should be enforced for all SQL ...
  41. Checks whether shared resource DLLs will be updated, causing restarts for clustered SQL Server instances active on this node. ...
  42. Checks whether SharePoint is already configured. If the farm is not configured, you can use the PowerPivot Configuration ...
  43. Checks whether SharePoint is un-configured. If the farm is configured, this rule recommends that you skip the Database Engine ...
  44. Checks whether SQL Server 2000 system tables can be updated. We recommend that you do not allow system tables to be updated. ...
  45. Checks whether SQL Server 2016 shared components (such as IS, BIDS, Tools, SSMS, or BOL) are present on the machine, because ...
  46. Checks whether SQL Server Agent proxy account has been granted to the Public role. Returns True if a SQL Server Agent proxy ...
  47. Checks whether the account that is running SQL Server Setup has the right to back up files and directories, the right to ...
  48. Checks whether the blocked process threshold option is set lower than 5 and is not disabled (0). Setting the blocked process ...
  49. Checks whether the computer is a domain controller. Installing SQL Server 2016 on a domain controller is not recommended. ...
  50. Checks whether the CPU architecture of feature(s) you are trying to remove is different than the CPU architecture of this ...
  51. Checks whether the CPU architecture of feature(s) you are trying to upgrade is different than the CPU architecture of this ...
  52. Checks whether the database has suspect database pages. A database page is set suspect by error 824. This error occurs when ...
  53. Checks whether the dbo or a db_owner is assigned to a fixed server sysadmin role for databases where the trustworthy bit ...
  54. Checks whether the edition of the selected SQL Server instance is supported in this SQL Server edition downgrade scenario. ...
  55. Checks whether the open objects server option is set to 0, the optimal value on instances SQL Server 2000. Using a nonzero ...
  56. Checks whether the specified drive is FAT32 file system volume. Installing on a FAT32 file system is supported but not recommended ...
  57. Checks whether the SQL Server service can be restarted; or for a clustered instance, whether the SQL Server resource is online. ...
  58. Checks whether the value of the locks option is the default setting of 0. This enables the Database Engine to allocate and ...
  59. Checks whether there are features that do not support SysPrep are installed on this machine. You can prepare a new instance ...
  60. Checks whether Windows PowerShell 3.0 (or higher) is already installed on system. Windows PowerShell is needed by some SQL ...
  61. CHECKTABLE object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!) processing encountered page ...
  62. check_expression - Is the expression to be checked for NULL. check_expression can be of any DMF supported types, Numeric, ...
  63. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary ...
  64. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters ...
  65. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters ...
  66. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters ...
  67. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters ...
  68. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters ...
  69. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters ...
  70. Chinese-Hong-Kong-Stroke-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters ...
  71. Chinese-Hong-Kong-Stroke-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters ...
  72. Chinese-Hong-Kong-Stroke-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters ...
  73. Chinese-Hong-Kong-Stroke-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters ...
  74. Chinese-Hong-Kong-Stroke-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters ...
  75. Chinese-Hong-Kong-Stroke-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters ...