graceb
Newbie
Points: 0
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
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 0 posts
You must be logged in to reply to this topic. Login to reply