LINK: http://weblogs.sqlteam.com/joew/archive/2007/10/23/60383.aspx
Why write a cursor to traverse each table – this stored proc allows you to traverse each table automatically:
EXECUTE sp_MSforeachtable ‘EXECUTE sp_spaceused [?];’;
Neat!
——————
LINK: http://weblogs.sqlteam.com/joew/archive/2007/10/23/60383.aspx
Why write a cursor to traverse each table – this stored proc allows you to traverse each table automatically:
EXECUTE sp_MSforeachtable ‘EXECUTE sp_spaceused [?];’;
Neat!
——————