:::: MENU ::::

Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

  • Dec 03 / 2008
  • 0
DBA Interview questions, dbDigger, Performance Tunning and Optimization

Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

The following error message
Msg 1929, Level 16, State 1, Line 1
Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

is a run time error message of severity level 16. It can occur on all versions of SQL Server. This error message appears when you try to create a statistic for an object that is not a table or a view. As errors of Severity Level 16 are generated and can be corrected by the user. To remove the error make sure that statistics can only be created for table and view objects.

Consult us to explore the Databases. Contact us