[ASP/MS SQL] - Couple of Q's

programming
1

Greetings,

  1. In your connection string do you(should you) specify a connection timeout?
    For example

[FONT=Verdana][SIZE=2]**MyConnection.ConnectionTimeout** = 30

If so what shoud that be, and what is the advatange or disadvantage to either setting it to infinity or a specified time?

  1. What would cause a table corruption in a MS SQL database table? Basically we have a site log table that logs the sites activity, that table out of no where became ‘currupted’?

  2. Currently when we reboot the server, our site isn’t available to anyone, is there a way without mirroring the server to either 1 keep that site up or add a message to people trying to access the site? We reboot the server every morning which was previously questioned by a bunch of members here - I’m not sure why we do it (it guy handles that).

So any info on these topics would be highly appreciated.

Thanks
[/SIZE][/FONT]