Lowell's script worked just fine for me.

Perhaps if you were to share the script you are using and details of the objects which aren't working...?

You really don't want to modify...

That reminds me...:-)

Question 8: What are the SQL...

NULL handling is a bit suspect too. I have made a few changes, while keeping the structure similar. Let me know if it improves things at all. ...

PRINT statements have a similar effect to omitting SET NOCOUNT ON. Whether the effect is big enough to be problematic depends on how many there are, how often the...

repent_kog_is_near (1/12/2010)

---

I do not (yet) use that trace. Do you recommend it? is it's only job to make sure SQL gets all the memory buffered at one time, in the...

Have you considered using the Maintenance Plan feature built-in to Management Studio? This allows you to 'set and forget' your backups (to a very great extent anyway). It...

You are welcome.

I like this article a lot. In fact, it is one of the very best I have come across on SSC. Congratulations are definitely in order, both for...

Vivek29 (1/12/2010)

---

Thanks guys.I am talking about shrinking log file after rebuilding indexes.And sometimes we require rebuilding of some indexes daily in production environment.So, is it worth changing recovery model...

Just noting that Lowell answered this question nicely on another thread by falcon59x.

Just for the record, it is still possible (and documented). I'm not going to go into...

True, but it...

Steve, I think Lynn deserves some bonus points for correct use of the word 'soliloquy' :w00t:

Just to expand on Gail's comment about the log structure, if you're interested to know more (and specifically to see which virtual log files are in use) see Exploring the...

Henry Treftz (1/11/2010)

---

You may want to look at doing an index reorganize instead of a full rebuild. Also if you don't have logic in that looks at fragmentation to...