Use textmerge to substitue the name of database
TEXT TO lcCmd TEXTMERGE NOSHOW PRETEXT 7
USE tempdb
exec sp_helpFile
USE <<gcDataDB>>
exec sp_helpFile
ENDTEXT
>
>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
>
>
--sb--