Wednesday, March 18, 2020

DBCC SHOW_STATISTICS -Cannot find a table or object with the name . Check the system catalog.



Don't forget the quotes
DBCC SHOW_STATISTICS ('schema.tableName','indexName')

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...