Crystal works, but check and see if does something you really need that SSRS can't do before you spend the $$$.

If you can move to SQL 2K8, or SS2K8 R2,...

The easy way to do this is write a script that checks if a particular job on your current server is still running. If that is the case, then you...

Reporting Services will allow you to do this. You would have to install it and create a report, but those can be saved as PDFs.

http://msdn.microsoft.com/en-us/library/ms159273%28SQL.90%29.aspx

ms_foreachtable might not work if you have FK relationships. I don't believe the RI will allow you to truncate the tables.

Nice trick for using Database Mail in SQL Server 2000. I must admit I was wondering how you were going to do this when reading the title.

Thanks, Carl. Good to have that handy.

SQL Saturdays have ranged from a low of 50-60 people to a high, I believe, of about 400. The more successful ones have been 300+, but space limitations sometimes restrict...

Congrats, Lynn.

Experience is nice, but it would be good to see some objective measurements on this. Not saying you're wrong, just would like it to be something other than a guess...

Jeffrey,

Do you have a 64 bit reference? I haven't seen this.

Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS. OS priority on memory...

Typically there are two places where i've seen this issue.

1. The plans were created on a version of SSMS that is different than the one you are using. This is...

It look like you have no limits on SQL Server memory, which is OK if this is a dedicated SQL Server machine.

you might want to read this blog (http://sqlblog.com/blogs/lara_rubbelke/archive/2008/04/18/memory-pressure-on-64-bit-sql-server-2005.aspx), which...

What is pagefile system? Do you mean the page file set on disk? what are the settings for that?

Please don't do that. It's rather rude and improper. If you need to ask a question, leave it here. Or edit it to explain better, but don't just remove it.

LOL, not me, though I might not be the easiest person to work with all the times. It's stories I hear, or things I've seen at it is work. It...