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