create virtual website

  • 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?

  • 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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply