Advertisement
SQLSoldier

Untitled

Jan 14th, 2015
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.21 KB | None | 0 0
  1. Select OBJECT_SCHEMA_NAME(S.object_id) + N'.' + OBJECT_NAME(S.object_id) TableName,
  2.     S.name StatsName,
  3.     S.stats_id,
  4.     SP.*
  5. From sys.stats S
  6. Cross Apply sys.dm_db_stats_properties(S.object_id, S.stats_id) SP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement