Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×