Article ID: 949775 - View products that this article applies to.
Consider the following scenario:
- Fehler,  SQLServer-Fehler: 102, Falsche Syntax in der Nähe von '%'. [SQLSTATE 42000] (DownloadMSXInstructions).
- Fehler,  SQLServer-Fehler: 102, Falsche Syntax in der Nähe von '0xf2cd03d68967b44caaf3bb311c512703'. [SQLSTATE 42000] (ProcessJobMSXInstruction).
- Erreur,  Erreur SQLServer : 105, Unclosed quotation mark before the character string ', 16, 1, @msx_version) END'. [SQLSTATE 42000] (DownloadMSXInstructions)
Note The SQL Server Agent log is located in the same folder as the errorlog of the SQL Server. See description of parameter "-e" in the topic "sqlservr Application" in SQL Books Online for more details.
Service pack information for SQL Server 2008 R2To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2527041/ )How to obtain the latest service pack for SQL Server 2008 R2
You can avoid this error situation by setting the display language of your SQLAgent- account on the TSX- Server to US- English.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2.
Article ID: 949775 - Last Review: April 22, 2011 - Revision: 3.0