You can also disable the reports so they don't get generated at all (my preference, since they are rather useless IMHO). Open the maintenance plan and click on the...

This actually does not have anything to do with the database snapshot that you created. If you look at the message, the error is on the MSDB database:

Executing the...

Jason-181907 (9/21/2009)

---

For those that use "simple" recovery model, when it comes to backups, does it matter if you are doing full backups or simply backing up the .mdf/.ldf files? ...

Are both instances running SQL Server 2008?

You are never going to be able to rebuild that index - because it is not an index. It is a HEAP (Index ID: 0).

If you need to reorganize...

scott.lothert (9/17/2009)

---

That's a great point Jeff ! I will make that correction.

Both query plans actually are using Index Seeks, the Unicode is doing a clusterd Seek. My bad for...

Review the article I link to in my signature - Gail does a very good job of explaining how to manage transaction logs.

What you are seeing is normal and expected...

Unless I'm missing something, you have a column defined as varchar - and you are passing in nvarchar data types. If you view the execution plans, I would bet...

And the solution was?

You would add that code inside the SUM, for example:

SUM(CASE WHEN...) AS ...

But, I would recommend using COALESCE and NULLIF instead of the CASE WHEN construct - so you would...

You have to run the service pack on all nodes in the cluster to upgrade the non-cluster aware services that exist on each node. For example, SSRS/SSIS will not...

Use sp_rename to change the name, but be careful to identify the permissions on the procedure before you recreate it. Dropping and creating stored procedures removes the permissions and...

Yes you can, but you need to install SQL Server 2000 first (and apply all service packs/patches), then you can install SQL Server 2008 as the default instance. If...

Well, that depends - if you are running on x86 hardware,...

Yes, you can probably assume that. SQL Server 2000 Standard Edition could not use more than 2GB of memory, regardles of how much was available on the server.

SQL Server...