Thanks for all the feedback. I think I have enough information to make a good case for upgrading our database server. I'm just a developer with the company and don't...

The drive being used is an Iomega LDHD-UP (Prestige). It is 1Tb in capacity. It uses 'Hi-Speed USB' to connect which has a 480Mbps speed and it has an 8Mb...

I'm working on getting the make and model of the drive to see if it is even usb 2.0. For now I'm just using it for backups that are like...

LOL. I thought it sounded off. But that is what was delivered when I told our IT guy that we might have better performance if we moved our transaction logs...

Please provide more details about your Maintenance Plan.

Is your SQL Server Agent Running prior to starting the creation of your maintenance plan?

Is it possible to post that document somwhere on this site?

I'll take a guess ... If you right-click on your database and select properties (in Enterprise manager) and then select the Transaction Log tab. Does location point to the previous...

She didn't elaborate on what the issue was. I'm back in the Office on Monday and will ask her though. I'll get back to this thread when I find out...

Actually the person I sent the 2000 mdf and ldf too said that the db attached fine to their 2000 and 2005 instance but wouldn't attach to their 2008. ...

Thanks GilaMonster! I got er done!

I should also mention that the reason I'm doing this is because someone added columns to the 2000 production tables and the 2008 version doesn't have those columns. Sp when...

Thanks for clearing that up for me. I get it now. I'll give it a whirl.

That sounds like it is a pretty bad deal and I sympathize with you. If you've been using it for a couple years you prolly have alot of data. Someone...

Thanks for your reply. Your solution looks more efficient than mine but I I'm not sure about the second half:

update TableA

set ID=NewID

from TableA join #TempTableA on ID=oldID

Am...

I think I might have a solution. SQL works best with sets but I don't see how to avoid looping through a table to accomplish this. If you can think...