MSSQLSERVER_102

  • Artykuł

Details

Product Name

SQL Server

Product Version

11.0

Product Build Number

 

Event ID

102

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

P_SYNTAXERR2

Message Text

Incorrect syntax near '%.*ls'.

Explanation

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