NP it happens.. 😉

Sorry I missed the part about who you were.

If you have an exact error as it happens we can defenitely help.

Back to call the vendor... nothing we can do here for you.

feersum_endjinn (11/16/2011)

---

Oh okay. Well the database option "Auto Update Statistics" is set to "true" so I'm hoping it will update all index based stats. Anyway now I have a possible...

Please don't cross-post (or hit submit twice).

Continue the discussion here => http://www.sqlservercentral.com/Forums/Topic1206797-391-1.aspx

What did you find in the install logs?

That's really have you have to go on if you don't call support.

Ninja's_RGR'us (11/16/2011)

---

It's a mam actually..

...backs...

The engine takes a lock for the delete operation, period. End of story. No...

feersum_endjinn (11/16/2011)

---

Data is imported into these tables via an SSIS package and I have an index rebuild on all the tables as the penultimate step - would this not update...

ashuthinks (11/16/2011)

---

its a huge long store procedure depending upon conditions

i insert data , update data and delete data from tables..

what i have posted is just a sample code of SP.

but...

It's a mam actually..

...backs away...

Stefan Krzywicki (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

jcrawf02 (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

jcrawf02 (11/16/2011)

---

L' Eomot Inversé (11/15/2011)

---

"yell":

/*

AAAA AAAA AAAA AAAA RRRRR GGGG HH HH...

Yes but that's a little pointless.

If you have runaway jobs or queries bloating the logs you need to know about them. Then fix the query, then resize the log.

It's...

SQLRNNR (11/16/2011)

---

And I...

feersum_endjinn (11/16/2011)

---

Ninja - I tested your theory by temporarily creating two tables to hold the data that the views returned and as you said it solved the problem. The execution...