sp_MSforeachtable sproc
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!
——————
Related posts:
- Struct Constructor Initialisation I'm working on a personal project atm (more details to...
- Rhino vs Moq All i can start with at this stage is wow........



