| title | MSSQLSERVER_102 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 264dc1a2-c8a0-4c89-b5f6-951baf950299 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| Product Name | SQL Server |
| Event ID | 102 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | P_SYNTAXERR2 |
| Message Text | Incorrect syntax near '%.*ls'. |
Indicates a syntax error. Additional information is not available because the error prevents the [!INCLUDEssDE] from processing the statement.
Can be caused by attempting to create a symmetric key using the deprecated RC4 or RC4_128 encryption, when not in 90 or 100 compatibility mode.
Search the [!INCLUDEtsql] statement for syntax errors.
If creating a symmetric key using the RC4 or RC4_128, select a newer encryption such as one of the AES algorithms. (Recommended.) If you must use RC4, use ALTER DATABASE SET COMPATIBILITY_LEVEL to set the database to compatibility level 90 or 100. (Not recommended.)