That's a good question, about what they're doing with the final output. I'll try to find out and see if another report is available or one needs to be...

Thanks Everybody, I'll probably write the custom indexing procedure, defragging only whats needs it and implementing a WAITFOR as necessary. much appreciated!

It will still warn me. The message I'm trying to modify slightly is one of the log shipping alerts. Our weekly index job creates a large transaction log...

Thanks, That worked as a workaround.

No this database has been around for several months. below is the data and log size

113039360 KB

5222400 KB

One thing I've just discovered. My data file WAS 112 GB...

Oh Ok, here's the rest of sp_spaceused

reserved- 88000048 KB

data- 76137600 KB

Index - 11880 KB

Unused - 11850568 KB

Thanks for your reply. I'm not sure what you mean there. Right click and go to properties? When I look at shrink files, I can't shrink...

This is what it was in my case. When I pinged any server, it would reply back once with my cluster Private IP and say destination unreachable and then...

THe linked server works sometimes. If I haven't used it in a while, the first time usually fails, but then succeeds everytime after that. Here's the exact...

I'm getting this same problem. Can you tell me how the issue was resolved?

Thanks!