There are a few possibilities:

1. nothing was "happening" in the db as far as writes were concerned, so even though the files where open, the mdf and ldf matched, so...

The NT/W2K architecture allows a 4GB virtual memory space for the server, 2GB for the OS and 2GB for any particular application. This can be altered with the 3GB switch...

Not sure how you'd do it in ASP, bascially you need some object to go through and "test" the URL. It would be similar to consuming a web service in...

Do you mean dead URL links? You'd need a cursor to run through all the values in the table and test each link. I'd do this with VB, get a...

for more info:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp

Personally I think it's a bad idea (http://www.sqlservercentral.com/columnists/sjones/wp_encryption.asp), but if you have to do  it, then key management will be the biggest headache. For live data as well as...

Good suggestions. We're fighting the bugs with the change in the forums, but these are good ideas for when we convert the rest of the site to ASP.NET. They make sense...

Use a table to store the message and then include that? Could us a

create table msg (spid int, mymsg varchar( 100))

 and put a row in for each line of...

Good idea, we'll look at getting that setup. For now a search on "worst practices" will turn them up.

I actually hadn't planned on the followup for "how to do this", but I've gotten a bunch of responses, so maybe I should.

I've got a couple of systems that I've...

I've tended to not defrag those folders where SQL data is located. My suspicion is that it would slow down IO, but it shouldn't affect the SQL Server, unless you...

Apologies. This is a strange one that Andy has been working to track down. Seems to work with IE6 and Mozilla 1.6 for me very consistently.

Last I heard was May timeframe.

I'd try updating MDAC, seeing if that helps.

Even in simple mode, this will be logged in one long transaction. Once it completes, the checkpoint will wipe it out, but until then it's all getting written.

I'd break it...