MSSQLSERVER_102
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Details
Product Name |
SQL Server |
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.)