June 2, 2003 at 11:52 am
Is it possible to create a virtual website through a stored procedure? Creating the files and folders are straightforward but how can I register the host header name?
June 2, 2003 at 2:59 pm
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply