Back up everything. Are you looking to patch Windows, SQL, or both? What patches?

I wouldn't call SQL 2000 old or fragile.

If you're really worried, I'd do a P2V migration...

There isn't a 64bit disk file and a 32 bit disk file. They are the same.

detach/attach or backup/restore as Lynn noted.

A couple things.

First, glad things cleaned up for you.

Second, if you shrink the database, you may undo all the work you did in rebuilding the clustered index to remove fragmentation....

Second vote here for DBCC CHECKDB. You cannot prevent corruption, so you need to run this regularly. If you can't do it every day, do it every week.

The checking, was...

The question had been corrected to note diff, but not full. I'll award back points as this was a tricky question with poor wording.

This isn't necessarily true....

stephanie.sullivan (5/29/2012)

---

IceDread (5/29/2012)

---

Most of you on this board is in the u.s. I believe however, and my gut feeling is that companies does not compete over workforce like this and...

Brandie Tarvin (5/29/2012)

---

We don't give Devs more than db_owner in the databases they need to have. For one, we do have a DBA admin only database that we develop code...

LogMeIn is one I've seen quite a few people using

http://itunes.apple.com/us/app/logmein/id479229407?gclid=CN-Dw4Two7ACFQcEnQodA048Xw&ls=1&mt=8&ef_id=94ZOuF@qoBQAAMPh:20120528210005:s

Firefly is on my Netflix list. Once I finish Battlestar Galactica

That will not work. Once you attach to...

fuller.artful (5/25/2012)

---

Excellent article, Steve.

...

Reason #2 is the big thing. "Kids" just crank up the editor and start coding. Experience teaches you to avoid coding until the last possible moment...

Jeff Moden (5/25/2012)

---

I've not run into that problem...

If sp_spaceused is the same a 2008, then there are queries against the allocation units system DMV. This is not necessarily going to be 100% accurate at a point in...

These should help

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-excel-worksheets-dynamically-in-ssis

http://www.sqlservercentral.com/articles/74225/

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/68025/

If you want to stick with your method: http://www.sqlservercentral.com/articles/Excel/64838/