NO to the shrink?

Yes. If you are shrinking the file after the rebuild, you are fragmenting the index. The defrag job will require the file to grow in order to defrag...

Are you shrinking the files daily along with your daily index rebuilds?

Yes change the 5 to a 7

Also, confirm which schema this new table was created in. You may have permissions on the schema but the object may not exist in that schema.

A query would be nice. An exec plan would be excellent.;-)

logicinside22 (1/17/2012)

---

@Manjunath

Hi i am working on same script. can you let me know how i can provide the network share location to delete old t-log backup file...

Scott Arendt (1/17/2012)

---

Jason, thanks for the suggestion, I'll keep it in mind for future use.

The problem was not in this expression, but in another similarly named column that still contained...

Since you are looking to join the SQL team where you work, ask to assist in a project or some slightly more meaningful tasks. By contributing where you are...

One of the best tools in the toolbox is a Virtual Lab.:cool:

GilaMonster (1/17/2012)

---

Steve Jones - SSC Editor (1/17/2012)

---

SQLRNNR (1/17/2012)

---

There's that, and some big money at stake. Somebody is also probably up for re-election or out to make a big name...

eardrum

Grant Fritchey (1/17/2012)

---

The House of Representatives have permanently shelved this abomination. We just need...

GilaMonster (1/17/2012)

---

Personally I just find it hilarious that the US denounces that kind of censorship in China and Iran, then considers implementing it at home. "Do what I say, not...

Do you have source control in place for other code?