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........
Tuesday, October 30th, 2007 at 10:35 am.
Filed under IT & Software.
Subscribe to RSS 2.0.
Leave a comment or trackback.
