If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs and verify you are...

I should mention that my response before the edit was completely predicated on the fact that I totally missed the comment "run sp" in the original post. I saw "update...

An UPDATE statement really doesn't have any effect except to alter the pointer information and possibly split your index leaves or fragment the indexes (if this causes them to be...

If the log files are corrupted, chances are that they are corrupted when they are being taken, not when they are being received on the log shipping side.

But this is...

I'm still a little iffy on my sum-total index knowledge, but AFAIK the answer is "no." Updating a clustered index updates the data rows, but does not update the leaf...

FYI: You might want to update the title of this thread to properly reflect your issue, which is security questions.

Look up Books Online for fixed database roles. Read and Write...

Kiara (1/27/2012)

---

Evil Kraig F (1/27/2012)

---

Roy Ernest (1/26/2012)

---

Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets...

Be very careful sending excel files through the mail. They tend to be too large for most people to send or receive.

You can either zip the file and send...

Careful, Francesc. You're making assumptions of foreign key relations based on names that could or could not have anything to do with the actual UserID. I've seen a lot of...

You are welcome. I hope it helps you avoid them. @=)

Is SQL Server Service started? If not, I'd also check your disk drives to make sure they aren't full.

So, question of the day. How do you help people who refuse to be helped? People who are resistant to your suggestions of "test it" or "try this".

I'm talking forum...

Roy Ernest (1/26/2012)

---

Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets run over with these...

All,

I received my answer to this question a long time ago. If you need assistance with a similar problem, please start a new thread as you are more likely to...

"Wish it were Sunday, cause that's my fun day."