Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_102

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 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.

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.)

Community Additions

ADD
Show:
© 2014 Microsoft