And if that column is referenced by other tables, you'll have to update those as well.....

ALZDBA (7/15/2009)

---

Have you run dbcc checkdb lately ?

I always use shrinkfile in stead of shrinkdb.

(what are the sizes of your db files)

Keep in mind your shrink operation will perform...

Gail ALWAYS remains the utmost professional, regardless of the situation. I don't know that I've seen any posts that have sent her off the deep end. She'll simply quit posting...

I don't think there is any "revert" happening here anytime soon.........

Ain't coming up for me either! The END is near, I fear.........The four horsemen be upon us!

Kit G (7/14/2009)

---

Gaby Abed (7/14/2009)

---

Hmmm...we're almost at page 666. Is it time to give in to the dark side? We should summarize this thread and perhaps list the...

Gail also has a couple of articles on her website talking about "log checkpoints/lazywriter" and "deleting logs" that might shed some light on the doubts you appear to be having...

http://sqlinthewild.co.za/

edit:...

Emails be a'flowing again. Woohoo - withdrawls are over!!

http://tinyurl.com/ncd9kk

http://tinyurl.com/ncd9kk

Not I!. That beauty happened at 7:00AM today. Exchange server was offline and nobody from infrastructure in yet. Could send or receive...

Not I!. That beauty happened at 7:00AM today. Exchange server was offline and nobody from infrastructure in yet. Could send or receive...

Not I!. That beauty happened at 7:00AM today. Exchange server was offline and nobody from infrastructure in yet. Could send or receive...

s007reddy (7/2/2009)

---

Once you moved the files (mdf, ldf) from Location1 to Location2, Stop and restart the instance of SQL Server. make it DB OFFLINE.

Refresh the Management studion and verify the...

Grant Fritchey (6/30/2009)

---

BTW, remember, friends help you hide the body. Sayings for the young men that come to visit:

I've got 15 acres and a shovel, they'll never find the...