Symptoms

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)


Cause

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.

Resolution

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

Status

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.

More Information

For more information about supplementary character collation, go to the following MSDN website:

Collation and Unicode support

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×