I don't see anything in the logs but I suspect permissions. Does the account running SQL server agent have appropriate rights to serverB? Trying logging into serverB using the agent...

Right click on the job under SQL Server Agent->Jobs. Then view history and check the "show step details" box. Highlight the failing step. It should provide more detailed info as...

What type of job are you executing? Is it writing a file? Is it a maintenance job (index rebuild, etc.)? What type of error is being logged for the job?...

Gail, would you recommend always running with repair_build or repair_fast? If not, why not? I've never used these options but in the OP's case, it might have fixed everything related...

GilaMonster (7/23/2008)

---

It looks like all the errors are in the nonclustered indexes. I would suggest dropping and recreating all of the nonclustered indexes and constraints on the table 'SyncServerState' and...

The service pack will work. And, trust me, it's a good thing to keep the client as patched as the server, however you do it.

GSquared - thanks for the tip....

Absolutely. That's also a good way of doing backups of VLDBs, especially if using native SQL. Allows you to slice it and dice it to meet your business recovery needs....

As I'm leaving for the day and don't have time to create a more robust example, try this on Northwind. Ten bucks says you get the same results...If you don't...

Unless I am totally missing something, wouldn't this do what you're looking for??

declare @lessdate = datetime

declare @greaterdate = datetime

set @lessdate = convert(datetime, '03/07/2008', 103)

set @greaterdate = convert(datetime, '03/07/2008', 103) +...

Why are you opening threads where an obvious resolution has been found or offered already, while adding little or no value to the...

Sounds like a good plan. Good luck.

TempDB's recovery mode is always set to simple....

-- Edit - The most important lesson to be taken from this...

This will work only if it's added to a different physical drive that has space available....

Watch which forum you post in, this is SQL2005. Anyway, check out the link below. Are these log backups or full? It appears logs based on the MS article. If...

Sorry, no experience on 64 bit (I assume that's what you mean), only 32 bit (I assume that's what you mean, also 😀 ). As far as user DLLs, I'm...