Assume that you have a Microsoft SQL Server 2012 instance that uses a supplementary character collation on the server level. When you first start the Database Engine Tuning Advisor (DTA), you receive the following error message when the DTA connects to a SQL Server instance:
Could not find stored procedure ' msdb..sp_DTA_help_session '. (Microsoft SQL Server、error: 2812)
Note In a Japanese environment, the error message is as follows:
ストアド プロシージャ 'msdb..sp_DTA_help_session' が見つかりませんでした。 (Microsoft SQL Server、エラー: 2812)
This issue occurs because some large object (LOB) data types are used to create necessary data structures in some tables or stored procedures that are used by the DTA when it is first started. However, the use of LOB data types is precluded in the supplementary character collation.
Service pack information for SQL Server 2012
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. We will update this article when there is an update.
For more information about supplementary character collation, go to the following MSDN website: