You can also use the maintenance wizard to reindex all tables on a specific database, leaving free space (or not) on each index for subsequent writes to the table.

I'm using RAISERROR('FYI: This message should be sent without delay', 10, 1) WITH NOWAIT and I cannot find it in the application log, sql server log or the errorlog. What...

Be sure to do a full backup after the truncate_only. I'm wondering, what exactly are the ramifications of truncate_only? Is it only clearing unneeded transactions?

Quest software has a few neat tools, like Spotlight. It's a newer product taht could be a little more robust but they promise that they will get there. Download the...

My linked servers also show isremote = 1. BOL appears to be incorrect.

Disregard my last reply. I found what I was looking for on Microsoft (I should've paged down!)

What is working set size? I cannot find a reference to it on Microsoft's website or BOL.

Yes, the account could lock pages in memory.

Awe was enabled.

Only one instance is running.

Max Server Memory to 4GB.

It appeared that the jobs running would start locking the remaining 2GB meant for the...

Sorry, it is advanced server.

SQL 2000, sp3 Enterprise Edition

Windows 2000, sp4

Jonathan, we're trying to utilize 4GB and can't quite get it to work. Unfortunately it's a production box that we can't play around with much (we have a new server...

Do you not also need to grant the service account right to lock pages in memory or do you do this only if you go beyond 3GB?

Thanks Allen. I appreciated the suggestions.

Terry

Also, if I setup the alert, will it write to the event log? We use a product called ELM that sweeps the event log and notifies the appropriate personnel.

Terry

Should I use size from sysfiles? Right now it shows 83977 for a 500 MB log.

Terry