Server Maintenance - 12/30/05

Wondering if any one else had the problem?

Last night about Midnight central standard time, one of the classic asp pages I was developing, stoped working.
It could not connect to my discount.asp SQL server.

I could get into the SQL server through the web administration tool discount.asp provides, as well as connect to it through QA, and query tables etc..
Everything seemed fine, but for some reason, the connection would return no record sets, when the asp page trying to query it.

I didn't change a thing, I decided to go to bed, and this morning it was working fine!

What could cause this sort of problem? And is there a page, where I can check for server maintenance times etc?
If that is what was causing it?

 

This is the error I am getting. I am working with another database now, and the problem has come up again.
It's after I make a change to the database, but I'm not changing anything that should create a problem.
For example, the page was working, then I created a trigger on a table. Now the page isn't working.
I get this error.

Can anyone point me in the right direction on how to prevent this?

 

I did a detach and then attach on the database and it fixed the problem.
I am guessing the problem is due to changing the databse I.E. adding a trigger, while there was an active connection.
But I am not sure how to prevent this, or drop any connections to the database, so the asp page will work again after the changes.
I'm sure this is something I'm doing in the wrong order, but I need some tips to point me in the right direction.