tag:blogger.com,1999:blog-9075786158122089104.post6095037477949491257..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Find size of each table in database of SQL Server 2005/2008Ritesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9075786158122089104.post-73473440458578426252009-10-01T15:46:14.448+05:302009-10-01T15:46:14.448+05:30it is easy to use and handy too. more readable als...it is easy to use and handy too. more readable also. ofcourse you can iterate loop or cursor but I still go for undocumented SP. as it is not giving wrong results and works fine in both (SQL Server 2005/2008). may be it won't work in next version but as long as these two version concern, I would go for this.Ritesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-50254557294059962082009-10-01T15:24:14.162+05:302009-10-01T15:24:14.162+05:30As sp_msforeachtable is undocumented, you can avoi...As sp_msforeachtable is undocumented, you can avoid it and simulate it using the following methods<br /><br />http://sqlblogcasts.com/blogs/madhivanan/archive/2008/05/13/simulating-undocumented-procedures.aspx<br /><br />MadhivananUnknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.com