sp_helpfile

• 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

  More actions

  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

  Andy
  Connect with me on LinkedIn