Sergey

The links helped, I'm now trying to include information about the TEMPDB file, and I can get the information with sp_help by first switching to the tempdb, but I can't switch back after getting the data. My database name (varies by how it was established on site) is stored in a global variable, but I get an error when trying the following:

TEXT TO lcCmd noShow
USE tempdb
exec sp_helpFile
USE ?gcDataDB
ENDTEXT 
IF SQLEXEC(gnConnHandle,lcCmd,"Cur1")<1
   =sqlerror()
ELSE
  * format data code here
ENDIF 

Do you know a trick here?

Thanks