I found this:

9104 essentially means that auto statistics failed for some reason (deadlock, resource crunch, ...). Since the engine can go on without auto-created or auto-refreshed statistics, the engine doesn't...

I want to bump this up again, as I have proved that an active directory user that is part of an active directory group that has only public permissions can...

TomThomson (8/29/2014)

---

rbartram-847800 (8/28/2014)

---

I have a similar issue.. I want all my steps in a job to go to the next step even if the step fails but I want...

GilaMonster (7/22/2014)

---

No, of course not. If that was the case, how would a restore ever work for a database larger than physical memory?

They're buffers, in the normal computer science definition...

Thanks Gail and Bob, but what I am really curious about is how that works; i.e. is the database restored into memory and then written to disk? It just doesn't...

I think it was spam...

Jeff Moden (5/28/2014)

---

SQLRNNR (5/28/2014)

---

SQLKnowItAll (5/28/2014)

---

Thanks for the thoughts. The list of connect items is really where I was focused, but I was curious of anything else that people have seen....

Jeff Moden (5/28/2014)

---

Interesting and I'm curious. What is it that makes you...

Thanks for the thoughts. The list of connect items is really where I was focused, but I was curious of anything else that people have seen. We'll continue our testing...

nimalatissa (5/19/2014)

---

I spoke to may manager about creating SSIS packages for handling this situation. His answer was why all other 50+ servers are working fine and not this one. He...

Is your manager...

sql_novice_2007 (5/15/2014)

---

Hi,

We are upgrading the sql server 2008 database server to SQL Server 2012.

For this just restoring DB backups from 2008 server onto 2012 is good enough for the upgrade...

lkennedy76 (5/15/2014)

---

Here is a script that you can use to sync your users back. You will have to add them manually to the new instance under Security. Once the DB...

Also remember, distributed transactions and cross-database transactions are not supported. That is their biggest drawback, in my opinion. Of course, if you don't have either of those, go ahead. Also,...

Oh also... No schedule for your job? I didn't see one in your script.