Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Details
| Attribute | Value |
|---|---|
| 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 isn't available, because the error prevents the Database Engine from processing the statement.
User action
Search the Transact-SQL statement for syntax errors.
Symmetric key encryption on older SQL Server versions
This error might 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.
If you want to create a symmetric key using RC4 or RC4_128, you should select a newer encryption such as one of the AES algorithms.
Caution
RC4 algorithms aren't recommended. If you must use RC4, you can use ALTER DATABASE SET COMPATIBILITY_LEVEL to set the database to compatibility level 90 for SQL Server 2005 (9.x), or 100 for SQL Server 2008 (10.0.x) or SQL Server 2008 R2 (10.50.x).