Archive for October, 2007

sp_MSforeachtable sproc

« 30 October 2007 | 10:35 | IT & Software | No Comments »

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!

——————



The Tomes Of Experience - powered by WordPress (themed by selder) 0.277 seconds.
07:04:06 21-11-2008