| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_102 |
MSSQLSERVER_102 |
MashaMSFT |
mathoma |
randolphwest |
03/28/2024 |
sql |
supportability |
reference |
|
[!INCLUDE sql-asdb-asdbmi-asa-pdw]
| 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].