muthukkumaran (12/2/2009)

---

GilaMonster (12/2/2009)

---

muthukkumaran (12/2/2009)

---

Hi,

Read & use the index de-fragmentation script added in my signature.

Why does your script use deprecated objects (that will be removed in future versions) and global temp tables?

Also, if you're using Try .. Catch, you shouldn't be using @@Error. There are updated functions in SQL 2005 for getting error details

Gail,Thanks for the update & Suggestion.I ll edit and post Script ASAP.