Try updating the statistics, then forcing a recompile of the procedure you are having trouble with after the truncate/inserts.  You might want to do this periodically several times after the...

Have you tried using status 0 instead?  Set the status to zero, move the file to a sub-directory, restart the trace.

You can also always copy the file while it's still...

Instead of restarting the server, try updating the statistics on the table in question.  Does that solve your issue?

and how are you deleting the trace?

If you are talking about a SQL Server cluster, there is no true active-active cluster.  You can use two servers and setup:

active-passive

passive-active

as your instances.  This will, in effect, be a...

If you mean the default data and log file settings, that hasn't really changed.  You just need to right-click on the server instance in object explorer, go to properties, go...

SQL Server 2000 support it.  Why wouldn't 2005?

The 8.00.250 is 2000 No SP+Q291683.  That means you are running without ANY SQL Server service packs.  You need to patch badly.

You can find good crosstab examples by going to http://www.sqlteam.com, clicking on the articles, and searching for either pivot table or cross tab.  There are two or three pretty...

The best way to do this would be to have an application that looks at the user table and sends emails or is triggered when they initially sign in.  Alternatively,...

You can run the osql command with trusted authentication and change the default database if you have sufficient rights.  When you run osql, it doesn't validate the default database.  Run...

David, he won't need AWE if he has 64-bit Windows and SQL Server.  All the memory will be directly addressable.  That's one of the biggest features of 64-bit computing.  The...

Craig, why are you trying to shrink the log file?  If you don't need the space, you might want to leave it alone.  Otherwise, it will just have to grow...

Where are you getting this error from?

Have you checked your antivirus to make sure it's still excluding the data and log files?  We had someone change that a month or so ago while they were "improving"...