| title | MSSQLSERVER_102 | |
|---|---|---|
| description | MSSQLSERVER_102 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.reviewer | randolphwest | |
| ms.date | 03/28/2024 | |
| ms.service | sql | |
| ms.subservice | supportability | |
| ms.topic | reference | |
| ms.custom |
|
|
| helpviewer_keywords |
|
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]
| Attribute | Value |
|---|---|
| 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 isn't available, because the error prevents the [!INCLUDE ssDE] from processing the statement.
Search the [!INCLUDE tsql] statement for syntax errors.
This error might 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.
If you want to create a symmetric key using RC4 or RC4_128, you should select a newer encryption such as one of the AES algorithms.
Caution
RC4 algorithms aren't recommended. If you must use RC4, you can use ALTER DATABASE SET COMPATIBILITY_LEVEL to set the database to compatibility level 90 for [!INCLUDE ssversion2005-md], or 100 for [!INCLUDE sql2008-md] or [!INCLUDE sql2008r2-md].