Phil Parkin (8/1/2011)

---

You can't do that - all of your field references will be to the situation as it was 'before update'.

So you need to write things out in full...

What are they doing that's so special on the stats?

Need help over here... can't explain why stats are getting dropped with no apparent good reasons :

http://www.sqlservercentral.com/Forums/Topic1151771-391-1.aspx

Tx.

brian118 (8/1/2011)

---

Ninja's_RGR'us (8/1/2011)

---

brian118 (8/1/2011)

---

Ninja's_RGR'us (8/1/2011)

---

Well for sure editing an index could cause this.

This is the first I hear of stats being dropped. Tho I can understand the decision behind...

Can you send a copy over, I used to love...

Go for it, @ 85% you're definitely in the top 1/5 of all applicants ;-).

sjimmo (8/1/2011)

---

I disagree. Globally setting autoupdate statistics to on can have a deterimental effect on your system if it decides to...

brian118 (8/1/2011)

---

Ninja's_RGR'us (8/1/2011)

---

Well for sure editing an index could cause this.

This is the first I hear of stats being dropped. Tho I can understand the decision behind the behavior.

Other...

That'd be nice!

BeerBeerBeer (8/1/2011)

---

I wish, but all we have is

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no...

And another one almost just as beautiful!

And this is my 17K post :w00t:.

Definitely yes.

The server waits untill 20% of the rows have been...

Which internal expert should I call in for this one?? I'm drawing blanks ATM.

ALZDBA (8/1/2011)

---

is there a query exception recorded in e.g. errorlog ( deadlock / error with Severity levels from 20 through 25 are considered fatal. If a fatal severity level is...