Couple of posts made while I wrote mine. You might want to add a manual checkpoint after the commit transaction.

Okay, I'm at a loss right now. I know the title says the database is using the simple recovery model, but just to be sure could you verify that...

Stefan Krzywicki (4/5/2012)

---

Lynn Pettis (4/5/2012)

---

Jan Van der Eecken (4/5/2012)

---

I don't know, but I'd give the OP the...

GilaMonster (4/5/2012)

---

Lynn Pettis (4/5/2012)

---

Has anyone written up what happens to a table when a clustered index is dropped making the table a heap? What I am wondering is if...

Jan Van der Eecken (4/5/2012)

---

I don't know, but I'd give the OP the benefit of the doubt....

Possible to see your code?

Any chance of getting the information we requested?

Any possibility of a scheduled backup or someone else running a manual backup?

If your stored procedures were written to log this information prior to doing any actual work, then you would have a method to see this, but that sounds like a...

No. There isn't any view that you can query to tell you what parameters where passed in.

Has anyone written up what happens to a table when a clustered index is dropped making the table a heap? What I am wondering is if the order of...

And if you dropped the existing clustered index first, that also would have caused any currently defined nonclustered indexes to be rebuilt as well.

The data had to be sorted into the logical order of the clustered index. In addition, if the table had any nonclustered indexes defined, those also had to be...

Lynn Pettis (4/5/2012)

---

You know, I'm not so much concerned about people that can't read, they can learn. My problem is with people that can read but can't seem to...

You know, I'm not so much concerned about people that can't read, they can learn. My problem is with people that can read but can't seem to comprehend what...