MSSQLSERVER_102
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).
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru