graceb
Right there with Babe
Points: 734
More actions
July 16, 2001 at 6:03 pm
#57620
I want to show physical files and size of all dadtabases, not just one, how do I do it?
Andy Warren
SSC Guru
Points: 119902
July 16, 2001 at 6:51 pm
#417101
Take a look at this article, shows how to use the undocumented sp_msforeachdb - basically hides the work of opening a cursor and running through the list from sysdatabases.
http://www.sqlservercentral.com/columnists/bknight/sp_msforeachdb.asp
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply