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....

Look at sysjobhistory in msdb. The message column will give you minimal details about failures (run_status = 0). The table seldom has the space to store all the details of...

It sounds like someone or something is removing the data source connection from SSRS.

Check the report to see where the data source connection is pointing to. Often times, SSRS will...

I don't advise shrinking it at all. The log space is growing because the database needs it.

If you're running out of hard drive space, add more as either a...

Hey, all. I don't know much about this subject (Other Wait statistics). Can anyone help this poster? He hasn't had any answers at all since he posted early yesterday:

http://www.sqlservercentral.com/Forums/Topic1158300-146-1.aspx

Linked server is exactly right. Usually, you will have a local login mapped to a remote login to provide access between servers.

Look up Remote Login Mapping in Books Online for...

IP change may affect your Foundation agents / hubs and your cluster virtual name (may need to refresh the link). Other than that, it shouldn't affect much. (I think.).

However, this...

Depends. Was SQL Server down or restarting during this incident?

If not, it's probably a network issue or the ODBC was deleted, or the users lost permissions to reach the ODBC,...