The host header name is usually important to the web server itself, not the SQL Server, even if you are storing files in the database or with the help of the database.
If you're hosting multiple web sites and the host header is important, you'd need to capture the host header at the web server and pass it back through the stored procedure. In the schema you'd probably have a table with all the host headers and a primary key and that PK is used as a foreign key in the table(s) for your files and folders.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley