How do I automatically change the default.html page?

Question

I have an IIS 6 site pointing to a sql2005 server and when I reboot the db server I want a new page to be posted called app_offline.html (or similar). Then, when the db server comes back online and connectivity is restored I would like the page to change back to default.html. -Any and all help is appreciated.

Answer 1

I'd recommend making a index.html site into an ASP site, and run a query against the database that will return some static output, like checking the table isworking for row1 col1 and have that value =10. If 10 is returned then default.html is sent to the user, else the app_offline.html site is loaded.