using sp_statistics for the first time

• Stéphane Thinel

  SSC Veteran

  Points: 277

  More actions

  September 25, 2009 at 6:39 pm

  #226555

  I'm trying this command base on what I have read on the help collection of SQL server 2008

  USE AdventureWorks2008

  GO

  sp_statistics @table_name = Employee

  GO

  I receive the result sets in the Results pane but no data under any column

  What do I do wrong?

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  September 28, 2009 at 7:04 am

  #1058986

  You need to also pass in the owning schema of the table as @table_owner.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning