We don't run antivirus software on any of the nodes.

I don't administer the SAN, but I've asked those administrators to look at I/O. They aren't in agreement that it is...

The Distrubution cleanup job runs every 10 minutes. I believe that this is a default interval and its always been set to 10 minutes. It seems to run okay even...

These are the best blogs I've seen regarding this issue. The resolutions they discuss worked for us.

http://blogs.msdn.com/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx

http://blogs.msdn.com/mariae/archive/2008/12/11/unable-to-load-client-print-control-error-in-reporting-services-2005-after-installing-kb956391.aspx

I have to ask: Why would someone design a database with a table containing 275 columns? I can't imagine a valid business reason for doing this.

Find out why the...

It's not a good idea to grant any additional rights to the Public. The preferred method is to:

1. Use Windows Athentication. Hopefully you are doing this.

2. Create a Windows group.

3....

We had this same problem with log (.txt) files, and never did find a solution.

You could try running the following as a Schedule Task:

@echo off

echo.

echo Removing old bak files

forfiles /p...

We ended up getting our Production (the publisher) instance back, so we never had to follow through on the Identity column issue. I just know that we couldn't just start...

You may run into an issue with Identity columns. We had an issue with this a few years ago when we stopped replication and tried to use the subscriber databases...

If you're not currently running replication, you probably won't have any problems moving the distribution database files.

If you were actively running replication, I'd try this:

-- 1. Stop the Log Reader...

I assume you're talking about using sp_send_mail.

I think you can zip-it and then just send the one zipped file.

Looks useful, but your code as posted does not parse for me.

You might be able to use this with some modifications for SSRS...

http://www.sqlservercentral.com/scripts/Email/64272/

You can place sp_start_job to start job 2 as the last step in job 1.

You will encounter this anytime you move a database from one server to another. These are called "orphaned users". This is a very common issue that DBAs must resolve. The...