And being totally snarky (forgive the humor during...

What changed between the time it was providing results and the time it stopped?

Any OS service packs? Any SQL Server hot fixes / SPs? Any major issues with your database(s)?

Is some other process going in and clearing off space from that location by deleting files it thinks are archived?

Are your older logs in the same location as the current...

To add a note on the current answers, REPLICATE() is a wonderful function. So is STUFF(), though STUFF() will actually replace an existing character, so be careful.

You can use them...

Another place to check is the usual assortment of certification books. They often have tutorials you can walk through yourself in how to use the various tools in SQL Server.

You're correct. The definition in BOL is pretty much identical, word for word, except for a final statement in the Insensitive part:

When ISO syntax is used, if INSENSITIVE is omitted,...

Ditto on the SSIS package. You can create it easily enough (aside from the learning curve), then schedule it with a job to run automatically.

If the other system is behind...

I'm a little confused by your post. Have you run other procs through DTA and gotten different results or do all your attempts to use DTA end up with no...

Steve Jones - SSC Editor (8/12/2011)

---

Is anyone here working with, or struggling to

- work in a complex development environment that does automated builds at high volumes (> 1x day)

-...

Have you checked SP_WHO2 while this is going on to see what the SPID of the blocking process is?

Here's the code I use to see what the details of a...

That's definitely one approach. Not knowing what your environment is like, I can't say for certain that it will help you narrow down the problem, but it's a good idea...

Stefan Krzywicki (8/12/2011)

---

Funny, we've been going to Worldcon for years, but we skipped last year because Australia was too expensive and we're not going this year because it is in...

Deepak,

No matter what you do, there will always be an element of manual work in this process. Someone will forget to add notifications to the job they create, or the...

The difference between tech writing and fiction writing?

Fiction writers get to lie for a living, disguising it as the truth.

Tech writers have to tell the truth, making sure the truth...

SanDroid (8/12/2011)

---

Brandie Tarvin (8/12/2011)

---

Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused....