Applies to: yesSQL Server (all supported versions)


Attribute Value
Product Name SQL Server
Event ID 102
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 Database Engine 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.

User Action

Search the Transact-SQL 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.)