Merge pull request #17711 from cobibi/sql-docs-pr-cobibi2

v-albemi · web-flow · commit 08fac817d0cf · 2020-12-08T07:29:08.000-08:00
Add 2 sqlserver errors-events articles on 10/28
diff --git a/docs/relational-databases/errors-events/database-engine-events-and-errors.md b/docs/relational-databases/errors-events/database-engine-events-and-errors.md
@@ -3988,7 +3988,7 @@ ORDER BY message_id
 |    8628    |    17    |    Yes    |    A time out occurred while waiting to optimize the query. Rerun the query.    |
 |    [8630](mssqlserver-8630-database-engine-error.md)    |    17    |    No    |    Internal Query Processor Error: The query processor encountered an unexpected error during execution.    |
 |    8631    |    17    |    No    |    Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it.    |
-|    8632    |    17    |    No    |    Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.    |
+|    [8632](mssqlserver-8632-database-engine-error.md)    |    17    |    No    |    Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.    |
 |    8633    |    16    |    No    |    The query processor could not produce a query plan because distributed query does not support materializing intermediate results with default in DML queries over remote sources. Try to use actual default values instead of default or split the update into multiple statements, one only containing the DEFAULT assignment, the other with the rest.    |
 |    8634    |    17    |    No    |    The query processor received an error from a cluster communication layer.    |
 |    8635    |    16    |    No    |    The query processor could not produce a query plan for a query with a spatial index hint. Reason: %S_MSG. Try removing the index hints or removing SET FORCEPLAN.    |
@@ -6399,7 +6399,7 @@ ORDER BY message_id
 |    15578    |    16    |    No    |    There is already a master key in the database. Please drop it before performing this statement.    |
 |    15579    |    16    |    No    |    Adding an encryption to the symmetric key failed. An encryption by the same %S_MSG '%.*s' may already exist.    |
 |    15580    |    16    |    No    |    Cannot drop %S_MSG because %S_MSG '%.*s' is encrypted by it.    |
-|    15581    |    16    |    No    |    Please create a master key in the database or open the master key in the session before performing this operation.    |
+|    [15581](mssqlserver-15581-database-engine-error.md)    |    16    |    No    |    Please create a master key in the database or open the master key in the session before performing this operation.    |
 |    15583    |    10    |    No    |    The module being signed is marked to execute as owner. If the owner changes the signature will not be valid.    |
 |    15584    |    10    |    No    |    An error occurred while decrypting %S_MSG '%.*ls' that was encrypted by the old master key. The error was ignored because the FORCE option was specified.    |
 |    15585    |    10    |    No    |    The current master key cannot be decrypted. The error was ignored because the FORCE option was specified.    |
diff --git a/docs/relational-databases/errors-events/mssqlserver-15581-database-engine-error.md b/docs/relational-databases/errors-events/mssqlserver-15581-database-engine-error.md
@@ -0,0 +1,71 @@
+---
+description: "MSSQLSERVER_15581"
+title: MSSQLSERVER_15581
+ms.custom: ""
+ms.date: 09/03/2020
+ms.prod: sql
+ms.reviewer: ramakoni1, pijocoder, suresh-kandoth, Masha, VenCher
+ms.technology: supportability
+ms.topic: "language-reference"
+helpviewer_keywords: 
+  - "15581 (Database Engine error)"
+ms.assetid: 
+author: suresh-kandoth
+ms.author: ramakoni
+---
+# MSSQLSERVER_15581
+ [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+
+## Details
+
+|Attribute|Value|
+|---|---|
+|Product Name|SQL Server|
+|Event ID|15581|
+|Event Source|MSSQLSERVER|
+|Component|SQLEngine|
+|Symbolic Name|SEC_NODBMASTERKEYERR|
+|Message Text|Please create a master key in the database or open the master key in the session before performing this operation.|
+||
+
+## Explanation
+
+Error 15581 is raised when [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] is not able to recover a database that is enabled for transparent data encryption (TDE). An error message like the following is logged in the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] error log
+
+> 2020-01-14 22:16:26.47 spid20s Error: 15581, Severity: 16, State: 3.  
+2020-01-14 22:16:26.47 spid20s Please create a master key in the database or open the master key in the session before performing this operation.
+
+## Possible cause
+
+This issue occurs when service master key encryption for the database master key in the master database is removed when the following command is run:
+
+```sql
+Use master
+go
+alter master key drop encryption by service master key
+```
+
+The service master key is used to encrypt the certificate that is used by the database master key. Any attempt to use the TDE-enabled database requires access to the database master key in the master database. A master key that is not encrypted by the service master key must be opened by using the [OPEN MASTER KEY (Transact-SQL)](/sql/t-sql/statements/open-master-key-transact-sql) statement together with a password on each session that requires access to the master key. Because this command cannot be run on system sessions, recovery cannot be completed on TDE-enabled databases.
+
+## User action
+
+To resolve the issue, enable automatic decryption of the master key. To do this, run the following commands:
+
+```sql
+Use master
+go
+open master key DECRYPTION BY PASSWORD = 'password'
+alter master key add encryption by service master key
+```
+
+Use the following query to determine whether automatic decryption of the master key by the service master key was disabled for the master database:
+
+```sql
+select is_master_key_encrypted_by_server from sys.databases where name = 'master'
+```
+
+If this query returns a value of 0, automatic decryption of the master key by the service master key was disabled.
+
+## More information
+
+In some cases, the instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] may appear unresponsive. If you query `sys.dm_exec_requests` dynamic management view, you notice that the `LogWriter` thread and other threads that are performing DML operations are waiting indefinitely with WRITELOG wait_type. Other sessions may also be waiting while they try to obtain locks.
diff --git a/docs/relational-databases/errors-events/mssqlserver-8632-database-engine-error.md b/docs/relational-databases/errors-events/mssqlserver-8632-database-engine-error.md
@@ -0,0 +1,58 @@
+---
+description: "MSSQLSERVER_8632"
+title: MSSQLSERVER_8632
+ms.custom: ""
+ms.date: 10/27/2020
+ms.prod: sql
+ms.reviewer: ramakoni1, pijocoder, suresh-kandoth, vencher, tejasaks, docast
+ms.technology: supportability
+ms.topic: "language-reference"
+helpviewer_keywords: 
+  - "8632 (Database Engine error)"
+ms.assetid: 
+author: suresh-kandoth
+ms.author: ramakoni
+---
+# MSSQLSERVER_8632
+ [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+
+## Details
+
+|Attribute|Value|
+|---|---|
+|Product Name|SQL Server|
+|Event ID|8632|
+|Event Source|MSSQLSERVER|
+|Component|SQLEngine|
+|Symbolic Name|QUERY_EXPRESSION_TOO_COMPLEX|
+|Message Text|Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.|
+||
+
+## Explanation
+
+Error 8632 is raised when you run a query in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] that contains a large number of identifiers and constants in a single expression. An error message like the following is reported to the user:
+
+> Server: Msg 8632, Level 17, State 2, Line 1  
+Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
+
+## Cause
+
+This issue occurs because [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] limits the number of identifiers and constants that can be contained in a single expression of a query. This limit is 65,535. For example, the following query only has one expression:
+
+```sql
+select a, b + c, d + e
+```
+
+This expression retrieves all five columns, calculates the addition operators, and sends three projected results to the client.
+
+The test for the number of identifiers and constants is performed after [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] expands all referenced identifiers and constants. For example, the following items may be expanded:
+
+- The asterisk (*) in the select list
+- A view
+- A computed column definition
+
+If the number after the expansion exceeds the limit, the query cannot run.
+
+## User action
+
+To work around this issue, rewrite your query. Reference fewer identifiers and constants in the largest expression in the query. You must make sure that the number of identifiers and constants in each expression of the query does not exceed the limit. To do this, you may have to break down a query into more than one single query. Then, create a temporary intermediate result.
diff --git a/docs/toc.yml b/docs/toc.yml
@@ -10637,6 +10637,8 @@
           href: relational-databases/errors-events/mssqlserver-8621-database-engine-error.md
         - name: 8630
           href: relational-databases/errors-events/mssqlserver-8630-database-engine-error.md
+        - name: 8632
+          href: relational-databases/errors-events/mssqlserver-8632-database-engine-error.md
         - name: 8642
           href: relational-databases/errors-events/mssqlserver-8642-database-engine-error.md
         - name: 8645
@@ -10775,6 +10777,8 @@
           href: relational-databases/errors-events/mssqlserver-15404-database-engine-error.md
         - name: 15517
           href: relational-databases/errors-events/mssqlserver-15517-database-engine-error.md
+        - name: 15581
+          href: relational-databases/errors-events/mssqlserver-15581-database-engine-error.md
         - name: 15599
           href: relational-databases/errors-events/mssqlserver-15599-database-engine-error.md
         - name: 15661
